dateTime value changing in Custom Form Report Template

[OscarSepulveda_III]

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!!

[Anonymous User]

diligentpig‌ can you take a look at this one?

Phil.

[KelliW]

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.

[JodyZhengLiu]

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...

Thanks,

Jody Zheng Liu