How to Display Datastore Dates in Excel
Excel does not automatically recognize the ISO 8601 format (the format the Datastore uses to store and export dates from a Datastore) as a valid Date/Time value. If you want to convert the stored Date/Time value from a datastore (for example, 2022-06-11T19:04:46.471Z) into a Date/Time that Excel can use (6/11/22 7:04 PM):
Use the following Excel function, changing A1 to the relevant cell in your spreadsheet:
=DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8))
Then format the field/column to your desired Date or Date/Time value.
Note: These times are all in GMT. You will have to perform additional conversions to account for other timezones.
Click here for an example Excel spreadsheet.
Updated over 1 year ago