Avatar

Correct answer by
Level 10

Presume that your Date field has the value pattern as DD/MM/YYYY

You can convert it's rawvalue into number of days using the following script in FormCalc

var firstDate = Date2Num(DateField1.rawValue,"DD/MM/YYYY")

now firstDate will have the number of days since epoch.

Next step you can add 1 to the firstDate and convert it back into Date Object using the following syntax

secondDateField.rawValue =  Num2Date(firstDate,"DD/MM/YYYY")

Similarly you can do it for all 13 date fields.

Nith

View solution in original post