dateTime value changing in Custom Form Report Template

Question

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

OT_Example_Geonet.xlsx

Overtime Payment Request_Template_v3.docx

头像.JPG

Fab_the_lab_0-1645607290731.png

JodyZhengLiu · Answer

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

KelliW · Answer

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.

Anonymous User · Answer

diligentpig‌ can you take a look at this one?

Phil.