format-date capturing local time, not UTC

lkline — Thu, 11 Apr 2024 20:43:10 GMT

I am attempting to create two variables that each capture the UTC date and time based on an esriFieldTypeDate calculation. Interestingly, the esriFieldTypeDate variable (${rovDplyEndFull}) is captured in UTC, as I expect, but another calculation formatting ${rovDplyEndFull} is reverting to local time. Here is a representation to explain:

type	name	calculation	bind::esri:fieldType
calculate	rovDplyEndFull	once(if(${rovDplyEnd} = 'End',now(), ""))	esriFieldTypeDate
calculate	rovDplyEndDate	format-date(${rovDplyEndFull},'%m/%d/%Y')
calculate	rovDplyEndTime	format-date(${rovDplyEndFull},'%H:%M:%S:%3')

Exporting the Excel output from Survey123 leads to this:

rovDplyEndFull	rovDplyEndDate	rovDplyEndTime
04/11/2024 19:42:54.703	04/11/2024	15:42:54:703

I would expect and am looking for the result for rovDplyEndTime to be 19:42:54.703. Since our form will be used across time zones, I am hoping to capture the UTC time. Changing the bind::esri:fieldType for rovDplyEndTime to esriFieldTypeDate led to an inaccurate result of something like "December 31, 1969".

Any ideas? I'm happy to provide more information as well.

topic format-date capturing local time, not UTC in ArcGIS Survey123 Questions

format-date capturing local time, not UTC