Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

What datetime format is this?

99 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I'm attempting to prep a table for import and need to recreate a concatenated formula field that includes a date field formatted like this:

Screen Shot 2023-01-19 at 7.50.14 PM.png

Can anyone identify this format for me?  Thanks!

3 Replies 3

Hey @Ashley_Jackson
This seems like it may be ISO 8601 formatted.

The ISO 8601 format is: YYYY-MM-DD.
So value of 20230118000000 would become: 2023-01-18.
The trailing six zeros are your time value. The zeros are simply there because there's not a specified time value with your data.

Normally the formatting of the time would go: YYYY-MM-DD T HH:MM:SSZ.
And of course, the [-6:CST] is just your timezone.

 

 

Thanks Ben - I will look into this today and confirm.  Thanks!

Hi Ben, I have been able to reproduce everything except two things:

  1. For some reason, my timestamp is loading as 00:01:00 instead of all zeroes
  2. The timezone at the end

Any suggestions for me?  Thanks!