I'm fairly new to scripting and have looked for an answer to this; I have found some posts though have been unable to apply them to my scenario.
I have one date that is automatically populated with the current date, and another (earlier) date that the user enters. I need to have a field which calculates the difference between these 2 dates in days.
Any help appreciated - I'll use any help as a learning exercise!
Regarding the change of output format make the following changes:
Set the Data pattern of your 2 date fields to
and the Display pattern to the one you wish to have
Change the calculation script (if you use mine in FormCalc) to
What this does is to use the data format of your fields to get the date values for calculation which stays fixed whereas your display format can then change because we do not use the formattedValue properties any more.