- dorsetholidayletsAsked 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.
- JotForm SupportdavidAnswered 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:
- dorsetholidayletsAnswered 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.