Skip to main content

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:

Can anyone identify this format for me?  Thanks!

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.

 

 

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!

Reply


Terms & Conditions