Set date depending upon choice

dorsetholidaylets
Asked on April 06, 2018 at 03:35 PM
I want to set a date into a date field if the user selects a certain option. I have tried copying the date from the value in the selection using the option "Use Calculation Values" as well as trying to update the date under a condition test but I am not get the correct date inserted.

For example, I want to insert the date of 1/4/2018 into the April Start date if the user selects April as the month.

Any ideas?

Regards
Page URL:
https://form.jotform.com/80902178504960
JotForm Support

david
Answered on April 06, 2018 at 04:34 PM

I actually had to do a bit of looking to see how this works. It seems the conditional date update uses a base date of unix epoch time or Thursday, 1 January 1970. In the condition, you use the number of days since that day to produce the correct date. April 1st for example would be 17,622 days:

Here's a quick test form to show how it works:

https://form.jotform.com/80955997721978
dorsetholidaylets
Answered on April 06, 2018 at 05:20 PM

Thanks for your help David, I thought it might have something to do with that. I found an easier work round, creating my own date to calculate from.