Date Differences

[C A]

How can I calculate the total number of days between two different dates?
Currently in the result field's xpath, I have "my:field2 - my:field1" and
"1.#QNAN" is showing up.

Also, can I have a field that gives the average hours of daylight and
another field that gives the average number of overcast days (I have this
information) depending on the month chosen in the date fields?

Thanks

 

[Scott L. Heim [MSFT]]

Hi,

To get date calculations you will need to write custom script. The
following BLOG entry has sample code and a sample project as well:

http://blogs.msdn.com/infopath/search.aspx?q=calculate+date&p=1

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.