topic Dates in ArcGIS Online in ArcGIS Online Questions

Dates in ArcGIS Online

LakshmiSankaran — Tue, 07 Apr 2015 20:41:43 GMT

I am noticing that a date e.g. 4/6/2015, entered in a SDE Feature Class (SQL 2008 R2) is translating to the day before in ArcGIS Online. The date field being a date-time field, and entered in as 4/6/2015 WITHOUT the time, is defaulting to 4/6/2015 12 am which is translating in an ArcGIS online map as 4/5/2015. Has anyone else noticed this?

Thanks

Lakshmi Sankaran

SDE Admin

Re: Dates in ArcGIS Online

KyleBalke__GISP — Tue, 07 Apr 2015 21:21:50 GMT

Yes we experienced the same issue yesterday when publishing from a feature class to a hosted feature service. I tried several fixes including setting the time zone as UTC without success.

Kyle Balke

Re: Dates in ArcGIS Online

SepheFox — Tue, 07 Apr 2015 21:23:59 GMT

This is a great post and a good catch, Lakshmi. I'm sure other users will find it useful to know about this issue.

Re: Dates in ArcGIS Online

MaryEllen_Perko — Wed, 29 Jul 2015 21:10:43 GMT

Hi. Does anyone know if there is a good way to get around this? I've read about a couple of options but neither is ideal:

1. Change the dates to UTM - which doesn't really work well for us when using internally hosted services in other applications besides ArcGIS Online/web apps.

2. Change dates to a text format - which is a little better until someone wants to filter or search for features on date ranges.

If anyone can point me to other options, I'd appreciate it. Thanks.

Re: Dates in ArcGIS Online

TimMinter — Wed, 29 Jul 2015 23:13:50 GMT

SQL Server queries can return unexpected and undesired date rounding. This might be what's happening between ArcGIS Server and SQL Server, and you might want to pursue this possibility.

Re: Dates in ArcGIS Online

RoyceSimpson — Fri, 18 Sep 2015 17:20:28 GMT

This is a known issue feature. Not sure how to get around it. Here's the AGOL doc on the topic. Go down to the Date section.

Work with fields—ArcGIS Online Help | ArcGIS

Re: Dates in ArcGIS Online

KyleBalke__GISP — Fri, 18 Sep 2015 17:43:28 GMT

Mary

My current work around is to create a new Date/Time field and then add one day to my original Date field using the Field Calculator:

DateAdd ("d",1, [DATE] )

Therefore my original date of 5/20/2000 becomes 5/21/2000 in the newly calculated field. I then publish to ArcGIS Online and my new Date field is correct since I have accounted for the date being dropped by one day. Hope this makes sense.

Here is the VB reference for the DateAdd function:

Understanding VB6's DateAdd function | Visual Basic 6 (VB6)

Best,

Kyle

Re: Dates in ArcGIS Online

MargaretM — Fri, 18 Sep 2015 17:48:11 GMT

Yes, we experienced this and I called ESRI Support about it. The answer is in ArcMap, go to the Time tab in Layer Properties and enable Time. Select the appropriate field for your date/time value and then set your local Time Zone. Then when you publish to AGOL, you'll have the correct date.

Hope this helps.

Re: Dates in ArcGIS Online

LakshmiSankaran — Fri, 11 Dec 2015 16:04:44 GMT

Thank you for your helpful replies

Re: Dates in ArcGIS Online

EdApalinski — Tue, 19 Nov 2019 20:08:59 GMT

Hi, the issue with this work around is you can only set the time property for one field in the feature class. If there are multiple fields i believe you can only set one.

Best

Re: Dates in ArcGIS Online

EdApalinski — Tue, 19 Nov 2019 20:24:11 GMT

Hi, the basic issue is time is published as UTM and then converted by the browser to local time. If the time is not defined arcgis assumes midnight UTM. For example if I publish a date of 11/1/2019 EST, the server will defaults that time to 11/1/2019 12:00 AM UTM, so when a web map looks at the time, the local browser converts it to EST by subtracting 4 hours, so you get 10/31/2019 8:00 PM.

I am not sure of the best work around for hosted layers with more than 1 date field (the time property can be set in the layer properties for a single field).

If you are publishing the service with arcgis server there is a way to set the local time so REST service dates will be converted properly by the browser. Here is a link to a tech support doc click How To: Set the UTC time field to follow a specific time zone

Best!