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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.