Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / July 2007

Tip: Looking for answers? Try searching our database.

Query about function in InfoPath

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mag - 20 Jul 2007 04:44 GMT
Recently, I am designing a leave application form.
And I encountered problem in one of my field.
In that field <Days>, I would like to apply SUBTRACTION which automatically
calculates the number of days in between two dates which would be entered in
the two previous  fields, formula I used is <Enddt - Startdt>.  The two
fields are in DATE format respectively.  Whenever I test the form, the word
'NaN' would appear in the field <Days>.  Could anyone help solve my doubt?
Thanks!
Kalyan G Reddy MVP (GGK Tech) - 21 Jul 2007 14:20 GMT
Hello

Please read the link below
http://enterprise-solutions.swits.net/infopath2003/article.php?t=datediff-vbscri
pt-infopath&c=infopath2003


I hope it helps you.
Signature

Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com

> Recently, I am designing a leave application form.
> And I encountered problem in one of my field.
[quoted text clipped - 4 lines]
> 'NaN' would appear in the field <Days>.  Could anyone help solve my doubt?
> Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.