topic Re: Date field issue in ArcGIS Online Questions

Date field issue

CameronMcCormick — Wed, 21 Aug 2013 11:47:34 GMT

Has anyone else had issues with date fields when uploading zipped shapefiles? We have a user who uploaded data that included a date field that is Date data type. The original data has an attribute of 8/12/2013, but when uploaded to AGOL, some of those records have the date changed to 8/11/2013. To make an even odder observation, if you download the data from AGOL, the records match the original data.
Any ideas?
Thanks!

Re: Date field issue

TimWitt — Wed, 21 Aug 2013 11:50:18 GMT

Do you have the same issue when you publish it as a feature service?

Re: Date field issue

CameronMcCormick — Wed, 21 Aug 2013 12:06:24 GMT

I haven't tried that yet, but another thing I just noticed was that in AGOL the record has 8/11/2013, but in Explorer Online, the date is 8/12/2013.
[ATTACH=CONFIG]26843[/ATTACH]

[ATTACH=CONFIG]26844[/ATTACH]

Re: Date field issue

TimWitt — Wed, 21 Aug 2013 12:12:57 GMT

In your organizational account is there a place where you can specify your timezone? I noticed funky things happening when publishing data with dates attached before.

The points for which the date is changed might be close to midnight and that's why it changes the date?

Re: Date field issue

CameronMcCormick — Thu, 22 Aug 2013 11:25:23 GMT

I haven't found any time zone information in our organization account.
After speaking with the data owner again, I've theorized that there's probably some data migration issues. The source was originally in an MS Access file that was geocoded to a .gdb and then converted to .shp and then edited and then zipped for AGOL.
Phew...

Re: Date field issue

RandyKreuziger — Fri, 23 Aug 2013 15:19:43 GMT

I think you're running into this

http://resources.arcgis.com/en/help/arcgisonline/index.html#//010q00000007000000

[INDENT]The date and time in a pop-up window do not match the date and time in the underlying data.

Servers store dates in Coordinated Universal Time (UTC). Web browsers convert the date to local time. For example, if you look at a time field in a pop-up window and you are located in California during standard daylight time, what you see is 8 hours earlier (UTC-8) than the time in the data. This offset might affect the date as well. If you look at a pop-up window with data from 7/7/2011 12:00 a.m., you see 7/6/2011 5:00 p.m.[/INDENT]

You can vote here to show your support for getting ESRI to fix the issue.
http://ideas.arcgis.com/ideaView?id=087E00000004SlJIAU

Re: Date field issue

KevinHigh — Mon, 30 Jun 2014 20:42:21 GMT

The solution I found came from a comment on that idea entry:

"If you enable time on the layer before publishing, it will apply the UTC offset to yoru local time."

I did this and it fixed the issue I was having with dates in AGOL.