topic Re: Date issue; date field shows one day back in ArcGIS Survey123 Questions

Date issue; date field shows one day back

Anonymous User — Thu, 17 Jan 2019 11:11:45 GMT

Hi!

I am new in Survey123. I have a survey form which is about collecting information about de-mined hazard areas. In the report date field the surveyors enter the correct date but when I download the information, it gives me one day back. I think this is due to different time zones between local and UTC.

Is there any solution to this to download and appear the same date in the form and in the download?

Re: Date issue; date field shows one day back

Jim-Moore — Mon, 21 Jan 2019 03:46:58 GMT

Hi Sayed

You're correct, times and dates are stored in Survey123 (and across ArcGIS Online) in UTC. Please see this useful post by James Tedrick‌ that has links that should help you to use pulldata("@property", 'utcoffset') to add a local time to your survey.

And this comment shows a quick example.

The time stored in Survey123, as well as the rest of ArcGIS Online, is UTC time; while browsers automatically compensate for that when displaying data, other applications and the export display the value as stored (as if there are no time zones). If you are using Survey123 Connect, you can include a question to retrieve a device's time zone, which you can then use to offset the time.
Work with date fields—ArcGIS Online Help | ArcGIS
https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis
Prepopulate answers—Survey123 for ArcGIS | ArcGIS (how to get the UTC offset)

Please also see the Dates & Time sample in Survey123 Connect for more on working with dates and times in Survey123.

Hope this helps.

Kind regards,

Jim

Re: Date issue; date field shows one day back

Michelle_Baragona — Thu, 30 Apr 2020 03:33:39 GMT

Hi Jim,

I'm wondering if you could help me with my very similar problem. The difference is that I'm pulling the date from a .csv file associated with the survey. The two fields are as follows:

I've looked around at the solutions you listed above, but I can't seem to get any of it to work. Any insight would be greatly appreicated.

Thanks,

Michelle

Re: Date issue; date field shows one day back

Jim-Moore — Sun, 03 May 2020 22:40:08 GMT

Hi Michelle

Perhaps this post by James Tedrick might be of use? Please see James' comments and his attached example, which demonstrates how to extract the date and apply the local UTC offset. Please let me know if this is useful.

Best,

Jim

Re: Date issue; date field shows one day back

Michelle_Baragona — Tue, 05 May 2020 16:24:56 GMT

That did the trick. Thanks so much!