Jotform Tables: Submission data in the downloaded excel file are an hour advanced

  • rhochie.brown
    Asked on November 5, 2021 at 3:50 AM

    Hi, I have two forms that have appointment booking.

    Recent appointments (for Nov. 8 onwards) get one hour added to when I download the entries to Excel. The Submission view is fine. For example: 9:00am-9:30am would show in Excel as 10:00am-10:30am.

    The previous entries for dates prior to Nov. 8 are correct.

    https://form.jotform.com/212867930586064

    1636098596 6184e22483633 Submission View Screenshot 101636098594 6184e22212b90 Excel View Screenshot 21

    Jotform Thread 3485947 Screenshot
  • Billy JotForm Support
    Replied on November 5, 2021 at 7:04 AM

    Hello,

    I hope you're doing well and thanks for reaching out.

    These submissions have been deleted from the table already. Do you mind if we restore them to see if we can replicate the issue?

    I've downloaded some of your data and the date and time didn't change. See the screenshots below:

    1636110251 61850fab3f294 Screenshot 10

    1636110224 61850f907714c Screenshot 21

    Kindly try again and let us know if the same issue persists. We'll be waiting for your response.

  • rhochie.brown
    Replied on November 5, 2021 at 9:13 AM

    Hi,

    I tried it again a few minutes ago. The reservations made for Nov. 5 and earlier have no issues. The ones made for next week (starting Monday, Nov. 8) are affected. Just out of curiosity, I noticed that November 7 is the end(?) of Daylight Saving Time. Do you think it has something to do with this?1636117748 61852cf4af6d9 Jot Sub Screenshot 101636117746 61852cf24c5a2 Jot Exc Screenshot 21

  • Nikola JotForm Support
    Replied on November 5, 2021 at 9:41 AM

    I was able to replicate the issue on a new form. The issue is probably related to Daylight Saving Time. I'll report it to our developers. If there is any update, we will inform you here.

  • rhochie.brown
    Replied on November 5, 2021 at 9:51 AM

    Great! Thanks so much.

  • Elton Support Team Lead
    Replied on November 8, 2021 at 7:14 PM

    Hi,

    We apologize for the inconvenience caused. The problem is now fixed. Kindly check.

    Thanks

  • Cami
    Replied on November 8, 2021 at 7:20 PM

    Hello,

    We are having the same issue. We don't have daylight savings here and constantly request that this is turned off. All of the new form templates also shows this error as one hour ahead.

    The last time we tried to check our submissions today too resulted in a new blank tab with no data.

    We are getting ready for a conference this Friday so do need to have this fixed as soon as possible.

    Thank you!

    Cami

  • rhochie.brown
    Replied on November 8, 2021 at 7:41 PM

    Good morning,

    Thanks so much! It's fixed!

    I know it's still months away but will the fix get affected when DST begins again next year (Mar. 13, 2022)?

    Thanks again.

    Rhochie


  • Elton Support Team Lead
    Replied on November 8, 2021 at 8:54 PM

    @Cami,

    We have moved your question in a separate ticket here https://www.jotform.com/answers/3494523 to avoid confusion. We will be on your own ticket shortly.

    @rhochie.brown

    Glad to know that it's fixed now. It should be fixed too in the next DST. But, if you come across issues, make sure to contact us again so we can help.