Hi Friends
I have date data that is being presented to me in a YYYYMMDD format. I am putting that in one column. I would like to create a formula column to convert that unstructured date column to a proper date format. Can anyone suggest the composition of that formula. I have tried a few things but nothing is working.
+18Hi @Dean_Lutrin - you need the DATETIME_PARSE formula:
Interprets a text string as a structured date, with optional input format and locale parameters. The output format will always be formatted ‘M/D/YYYY h:mm a’
So in your case something like:
DATETIME_PARSE({Your field name}, 'YYYYMMDD')
JB
Hi @Dean_Lutrin - you need the DATETIME_PARSE formula:
Interprets a text string as a structured date, with optional input format and locale parameters. The output format will always be formatted ‘M/D/YYYY h:mm a’
So in your case something like:
DATETIME_PARSE({Your field name}, 'YYYYMMDD')
JB
Thanks so much! Perfect… and simple.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.