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!