How to calculate local time?

vanessagiles

I am trying to calculate the local time (10 hours ahead of UTC) into a new field using this statement:

${dTime} + (1000 * 60 * 60 * 10)

But I get an answer that looks like its in EPOCH time (see attached.

How can I get the local time into a field in ArcGIS online? 

(If I leave it in UTC time then the dates are split by the midnight mark and I can't filter my map layers properly).

Capture.JPG

jCarlson_0-1610571782127.png

JayantaPoddar

Check if the following link is useful.

https://community.esri.com/groups/survey123/blog/2016/04/17/dates-and-time-in-survey123-for-arcgis?sr=search&searchId=004cd9c8-97b3-4f90-a7a8-ff3a02410f17&searchIndex=0‌

Calculations: Calculations are easy too, as long as you understand that dates in the Survey123 app are encoded as EPOCH time. When users pick a date or a date-time in the survey, all values will be presented in a human friendly way, but internally the application is actually handling them as numbers that represent the total milliseconds elapsed since 1970. A positive number represents a date after 1970 and a negative number a date in the past.  As you can imagine those are pretty big numbers, but the math is simple. For example:

 

Goal	Expression
Calculate a time 15 minutes into the future	now() + 15*60*1000
Calculate age from a birthday	int((today() - ${birth_date}) div (1000 * 24 * 60 * 60 * 365.25))
Time spent for lunch	int(${TimeLunchEnds} - ${TimeLunchStarts}) div (1000*60)
Two weeks into the future	now() + 14*24*60*60*1000