What datetime format is this?

3418 3
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

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!

7 - App Architect
7 - App Architect

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!