Seperate date and time when exported as CSV

In the simplest terms possible as I am not an Excel freak…when I export the grid data to a CSV or google sheet, the date and time always comes through like this 2021-09-24T07:30:00.000Z (which originally was input from Adelaiade Australia as 24/9/21 1700).

How can I write a formula to seperate 2021-09-24T07:30:00.000Z into 24/09/2021 and 07:30?

Any help would be great as this is a huge issue at the moment.

My date fields get exported in the format I’ve chosen in Airtable. Is your date field a proper date field? Can you change it’s format?

Is the date in a calculated field?

You can use a formula field with the DATETIME_FORMAT function to convert the date to a text string with either the date or the time. The formula field reference has details.

If you find formulas difficult to write, such as properly nesting SET_TIMEZONE, you can use the paid version of the app Ready Made Formulas.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.