Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Seperate date and time when exported as CSV

Topic Labels: Dates & Timezones
429 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

2 Replies 2

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.