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.