topic Re: dateTime value changing in Custom Form Report Template in ArcGIS Survey123 Questions

dateTime value changing in Custom Form Report Template

OscarSepulveda_III — Tue, 15 Aug 2017 03:31:30 GMT

I have three dateTime fields within my form.

Now()
Start Time (editable)
End Time (editable)
- Calculation between the two

When a survey is completed on my iPhone the dateTime fields show the correct information. Yet, when I go to print out the Custom Template the minutes on the two editable rows are incorrect and have identical minute values. Also, the 'Calculation' still shows the correct answer even though the times are shown incorrectly.

Attached is the XLSX and Template that are being utilized. This is driving me insane for the last couple of hours!!

Re: dateTime value changing in Custom Form Report Template

Anonymous User — Thu, 17 Aug 2017 10:23:49 GMT

diligentpig‌ can you take a look at this one?

Phil.

Re: dateTime value changing in Custom Form Report Template

KelliW — Fri, 09 Apr 2021 21:19:42 GMT

Did this ever get resolved? Something similar is happening where my time changes after it is submitted and shows up incorrectly on the custom report.

Re: dateTime value changing in Custom Form Report Template

JodyZhengLiu — Tue, 13 Apr 2021 09:49:44 GMT

Hi @KelliW ,

Are you in the same time zone as the submitter of data? The report will use the printer's time zone and UTC offset to interpret the UNIX time submitted. You can specify the utcoffset value in your template as documented here: https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereporttemplates.htm#GUID-A472089D-255C-4F58-BF20-4AA4ABFF5098

Thanks,

Jody Zheng Liu