Set date depending upon choice

  • Profile Image
    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?


  • Profile Image
    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:

  • Profile Image
    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.