Web Map shows wrong "beach sampling date" in popup window

DonBarker

I created a web map of beach monitoring sites and results for San Mateo County Calif.  The popup includes the sampling date.  The date in the popup does not match the date in the underlying data (feature service or shapefile or Excel table).  For example:

Data says 7/5/2011,   web map popup shows  7/4/2011 5:00 PM
Data says 5/17/2011, web map popup shows 5/16/2011 5:00 PM

This is consistently wrong for all the map points in all the popups.

The operational layers are on an ArcGIS server behind our county firewall, so you can't see them.  So I've documented and illustrated the problem in the attached 2-page PDF.  I hope you'll take a look and help figure this out.

Thanks.

Date display issue in AGO web map.pdf

IMG_20201103_093258.jpg

MikeMinamiP1

The server stores dates in UTC (Universal Time, Coordinated). The web browser converts the date to local time, which is UTC -8 for California (now -7 due to daylight savings time). Thus, all of your date displays are offset 7 hours earlier. So given a date like 7/7/2011 without a time (midnight) will display as 7/6/2011 5pm. This is just how dates work.

http://en.wikipedia.org/wiki/Coordinated_Universal_Time

I am assuming that the field in question is actually of type "date". Is this a time aware layer? The layer properties dialog in ArcMap (Time tab) lets you specify a time offset. You might try to enable an offset and serve your map out again. I'm not sure it will work with queries against the data, however, and I didn't try it myself. Another option would be to add a string field that represents the date. The browser won't convert the string field in this case.

Thanks,

Mike