Daylight saving time difference being applied to user entered dates (values after 3/12/23)?

SamuelFirmenich — Wed, 08 Mar 2023 21:07:27 GMT

I've noticed that when a user inputs a date (an input value before 3/12/23) into a date field, the Survey123 HFS data export output (CSV) will default to the date entered along with the time of 5:00 AM. My computer is currently set to Eastern Standard Time (EST), so this is to be expected since the backend of Survey123 is in UTC.

However, when a user inputs a date (an input value on or after 3/12/23) into the same date field, the data export will show the correct date but with the time of 4:00 AM as shown below:

This is creating an issue when a user generates a Survey123 report with records that have 4:00 AM because of the applied time zone change by Survey123 (-5:00) when exporting reports. In this case, the value 3/24/2023 4:00 will show the date 3/23/2023 on the report (3/23/23 23:00 after the applied time zone change).

Is there a solution or workaround for this? Is this going to be an issue when the next daylight saving time change occurs? It is currently affecting a workflow where a user is entering future dates (date values after 3/12/23) into the Survey123 table but when they export a report using the report template, it is giving the incorrect date.

Re: Daylight saving time difference being applied to user entered dates (values after 3/12/23)?

CherD — Thu, 04 Apr 2024 16:28:58 GMT

Did you ever figure this out? We are having the same issue.

topic Re: Daylight saving time difference being applied to user entered dates (values after 3/12/23)? in ArcGIS Survey123 Questions

Daylight saving time difference being applied to user entered dates (values after 3/12/23)?

Re: Daylight saving time difference being applied to user entered dates (values after 3/12/23)?