Conditional Logic: "Update/Calculate Field" condition is not copying the correct date when using it with date fields.

  • Profile Image
    samspar
    Asked on March 04, 2016 at 01:40 PM

    In my jotform, there is a field called "start date of event" and a hidden calculation at the bottom called "start date for calendar." See the conditional logic below:  

    However, the calculation isn't working. Start Date for Calendar consistently is one day earlier than it should be, whether Prep/Setup Day is equal to yes or no. I'm wondering if this has something to do with our recent leap day?

     

    Please help as this is causing a lot of problems!

  • Profile Image
    Kevin_G
    Answered on March 04, 2016 at 04:37 PM

    I have tested the condition on a sample form and seems like it is not copying the correct value, it is adding a previous date, I will escalate it to our second level so one of our developers will take a look and will fix the issue, you will receive news about it soon. 

    As a workaround while the issue is fixed, you may update your conditions and add a day to the current condition to get it working as expected, see the conditions on the image below: 

     

  • Profile Image
    samspar
    Answered on March 09, 2016 at 03:22 PM

    Can you provide an update on this please?

  • Profile Image
    jonathan
    Answered on March 09, 2016 at 05:09 PM

    Hi,

    Currently, the ticket was already assigned to one of our developer.It is at Opened status. Meaning it is being worked on already. Our developer assigned will notify you here once there is update/news available.

    Thank you.

  • Profile Image
    NicholasWestley
    Answered on March 09, 2016 at 06:33 PM

    Hi,

    This has now been fixed.  There will no longer be issues with inserting numeric dates into other date fields in the western hemisphere.

    Sorry for the inconvenience.

    Regards,

    Nicholas