Date Timezone in export form

#1

Hi,

I have developed one form and in project space i am using India timezone but in my export data the although it is showing the date correct but time is not correct.

So, for example i have submitted one form on 29th august 2019 at 11.30 a.m but in the export form it is showing 2019-08-29 05:54:51 where the time is incorrect.

Please suggest.

Regards,
Deeksha sharma

#2

Hi Deeksha,

Form Exports show 3 timestamps:

  • completed_time: The time when the form was submitted (based on device’s timezone)
  • started_time: The time when the form was initially opened (based on device’s timezone)
  • received_on: Time that the form was received by the server (UTC+00)

Please refer to this page for more info. Thanks.

Dev