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

[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?s...‌

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

[vanessagiles]

Thanks, I have read this blog post but I don't understand - how can I get the local time to display in a legible date-time format in my attribute table?

[JamesTedrick]

Hi Vanessa,

What product are you using to display the time information? ArcGIS Online automatically compensates for the time zone difference between your computer's local time zone and UTC.  ArcGIS Desktop (ArcMap and ArcGIS Pro) both have tools to compensate from UTC in the time display as well as calculate the difference in time zones on a table.

[vanessagiles]

Thanks James - I was viewing it through a browser using a shared URL (demo with users).  It was definitely not showing the local time.  ArcGIS online was displaying the local time this morning.  I will do some further testing to see if I can replicate the problem.

[JamesTedrick]

No worries- ArcGIS Online stores all time information as UTC (see Troubleshoot—ArcGIS Online Help | ArcGIS ).  Assuming the computer is aware of what time zone is, the browser should be automatically adjusting it in the display.

[Anonymous User]

Do you have a fix for the time being off in Survey123? My team goes out and log items and the time stamp for them is a date choice in the survey. But the time is off by 8 hours in the EST zone. Can the survey pull the time from their phone or device?