nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dates in ArcGIS Online

LakshmiSankaran

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

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

NJ-EdwardApalinskiGISS

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!

NJ-EdwardApalinskiGISS

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

LakshmiSankaran

Thank you for your helpful replies

MargaretMontgomery

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.

KyleBalke__GISP

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

RoyceSimpson

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

TimMinter

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.

MaryEllen_Perko

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.

SepheFox

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

KyleBalke__GISP

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.