topic Re: Date Fields when appending to hosted Feature Layers in ArcGIS Online Questions

Date Fields when appending to hosted Feature Layers

MichaelKelly — Tue, 06 Mar 2018 15:34:39 GMT

When appending data to hosted Feature Layers in ArcGIS Online via its Item Details page, is there a recommended format for date fields when uploading a .csv file? I encountered this error, but once I changed the date format (to something like 08/11/2018 17:00:00) it worked as expected. I haven't found any official documentation on this and wondered what needs to be considered when working with date fields in this manner.

Re: Date Fields when appending to hosted Feature Layers

RobertScheitlin__GISP — Tue, 06 Mar 2018 15:41:06 GMT

Michael,

Have you seen this help page and looked at the dates section?

Work with fields—ArcGIS Online Help | ArcGIS

Re: Date Fields when appending to hosted Feature Layers

MichaelKelly — Tue, 06 Mar 2018 17:03:23 GMT

That's exactly what I'm looking for - thanks Robert. In particular the following section is useful:

Enter dates in MM/DD/YYYY hh:mm:ss format

Regardless of how dates are displayed in the table, you can only enter dates in MM/DD/YYYY hh:mm:ss format, enclosed in single quotation marks. For example, to set a date field to 5:00 PM on May 27, 2014, you would type '05/27/2014 05:00:00PM', '05/27/2014 5:00PM', or '05/27/2014 17:00:00' (24-hour clock). Storing time alone is not supported—time must always be a component of a date.

Re: Date Fields when appending to hosted Feature Layers

RobertScheitlin__GISP — Tue, 06 Mar 2018 17:07:11 GMT

Great. Don't forget to mark this question as answered by clicking on the "Mark Correct" link on the reply that answered your question.