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

  • Profile Image
    rhochie.brown
    Asked on November 05, 2021 at 03: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 View1636098594_6184e22212b90_Excel View.png

    Screenshot
  • Profile Image
    Billy_G
    Answered on November 05, 2021 at 07: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_

    1636110224_61850f907714c_

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

  • Profile Image
    rhochie.brown
    Answered on November 05, 2021 at 09: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.png1636117746_61852cf24c5a2_Jot_Exc.png

  • Profile Image
    Nik_M
    Answered on November 05, 2021 at 09: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.

  • Profile Image
    rhochie.brown
    Answered on November 05, 2021 at 09:51 AM

    Great! Thanks so much.

  • Profile Image
    EltonCris
    Answered on November 08, 2021 at 07:14 PM

    Hi,

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

    Thanks

  • Profile Image
    Cami 
    Answered on November 08, 2021 at 07: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

  • Profile Image
    rhochie.brown
    Answered on November 08, 2021 at 07: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


  • Profile Image
    EltonCris
    Answered on November 08, 2021 at 08: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.