Seperate date and time when exported as CSV

[Shay_Clifford]

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.

[Per_Carlen]

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?

[kuovonne]

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.