I am trying to figure out a way to convert a datetime stamp of the last_edited_date (tracking changes) that is stored in UTC to local time.
I am putting together a map service that allows our heavy equipment folks to update road conditions for our campus during a snow storm. When users view the map I want to show the last edited date for each feature so people know how long ago a road was plowed. I want to pull the last_edited_date field and show it in a label. Unfortunately the time is UTC and the labels do not autoconvert to local browser time when viewing the map service. Since our heavy equipment folks are updating the map via a feature service, switching to Database time to the track changes in sde wont work.
I am hoping someone knows of some kind of expression to either straight up convert or at least know of someway to subtract 7 hours from the time (we are in the pacific time zone).
أكثر...
I am putting together a map service that allows our heavy equipment folks to update road conditions for our campus during a snow storm. When users view the map I want to show the last edited date for each feature so people know how long ago a road was plowed. I want to pull the last_edited_date field and show it in a label. Unfortunately the time is UTC and the labels do not autoconvert to local browser time when viewing the map service. Since our heavy equipment folks are updating the map via a feature service, switching to Database time to the track changes in sde wont work.
I am hoping someone knows of some kind of expression to either straight up convert or at least know of someway to subtract 7 hours from the time (we are in the pacific time zone).
أكثر...