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!
What datetime format is this?
+17
+22Hey @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.
+17Hey @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!
+17Hi Ben, I have been able to reproduce everything except two things:
- For some reason, my timestamp is loading as 00:01:00 instead of all zeroes
- The timezone at the end
Any suggestions for me? Thanks!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.