manipulation of dates

[faxof]

in microsoft infopath does anyone know how to find the difference between two dates?

i've tried the obvious of setting a field to = date1-date2 but i can't get it to work. any ideas?

much appreciation

fax

 

[AnotherHiggins]

i can't get it to work

What happened when you tried this?

[tt]_____
[blue]-John[/blue][/tt]

"Patriotism is your conviction that this country is superior to all other countries because you were born in it."
[tab]-George Bernard Shaw

Help us help you. Please read FAQ181-2886 before posting.

 

[faxof]

well - after inputting the two dates from two date pickers the text box where i wanted the result to go ended up with a red box around it and the value was "NaN

 

[xlhelp]

I don't know much about this, but from what I have read in other fora, this can only be done with code. Infopath does not have the ability to do datediff according to some of those postings.

http://www.geniusmedia.ca

 

[xlbo]

oh yes indeedy - there is not a lot you can do within the Infopath GUI - pretty much everything must be done in VB/Java script using event handlers

You need to get used to Nodes / XPath queries and other assorted XML terminology.



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question