Problems when updating date values in Feature Layer (hosted)

Question

I have an issue with a Date field from the Feature Layer (hosted) created with Survey123.

Selecting Update Data > Append Data to Layer uploading the data from an Excel file (xls or xlsx), then viewing the field named “OA Date” of Date type, in ArcGIS Online. The date value changes a date before.

For example:

Excel (xls or xlsx) – Update Data

Feature Layer (hosted)

Field: OA Date

14/04/2023

13/04/2023

Please anybody can help me on this?

dougbrowning · Accepted Answer

This is because the time is converted to UTC when stored in AGOL.  If there is no time given it defaults to midnight, which then in UTC can go back a few hours, taking you to the day before.  123 now defaults to noon on date fields to help with this but when appending it just defaults to what AGOL does.  Add a time to them all of noon instead.

Hope that helps