Timezone in API of updated_at differs 5 hours from actual time of updated in our timezone

  • CalderElearn
    Asked on November 22, 2019 at 4:13 AM

    All our submissions have a created_at and updated_at which seems to be noted in a different time zone than ours (EU/Amsterdam). Could this be set in our timezone, or maybe better, could you inform me about the timezone of these dates? Preferably this would also be available in the API..

    Regards,

    Joseph

  • Ashwin JotForm Support
    Replied on November 22, 2019 at 5:16 AM

    Please note that submission time is captured based on your account timezone setting. You can set your timezone in your account setting page. You may like to take a look at the following guide which should help you: https://www.jotform.com/help/346-How-to-Change-Submission-Date-to-a-Different-Format-and-Timezone

    Hope this helps.

    Do get back to us if you have any questions.

  • CalderElearn
    Replied on November 22, 2019 at 5:37 AM

    Hi Ashwin,

    It doesn't help. We have the timezone set to our timezone. Submission dates in submission view of Jotform are correctly displayed. The API has created_at and updated_at data, which is set on a different timezone, not affected by this setting. When we know what it is, we would be better able to synchronise data.
    Now it would be an unreliable guess whether we have already seen the data or not. With knowing which timezone you use, we can calculate the time that you use.

    Preferably this would be available in the API also, because you may vary this at some point too. 

    Regards,

    Joseph

  • Richie JotForm Support
    Replied on November 22, 2019 at 6:26 AM

    I have checked and it seems the timezone for the API is set on your account settings time zone.

    Timezone in API of updated at differs 5 hours from actual time of updated in our timezone Image 1 Screenshot 20

    You can also run a test here http://api.jotform.com/docs/#user-reports.

  • CalderElearn
    Replied on November 22, 2019 at 8:44 AM

    Hi Richie,

    I see, but this is our Timezone setting. Not the one of the updated_at and created_at that is only available in the API..

  • Richie JotForm Support
    Replied on November 22, 2019 at 8:58 AM

    Checked again and it seems our server is using EST to get the created_at in the API.

    Timezone in API of updated at differs 5 hours from actual time of updated in our timezone Image 1 Screenshot 30

    I have tested using the get form ID API http://api.jotform.com/docs/#form-id

    Timezone in API of updated at differs 5 hours from actual time of updated in our timezone Image 2 Screenshot 41

    Please give it a try and let us know if you have further questions.