Date Conversion

[Dean_Lutrin]

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.

[JonathanBowen]

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

[Dean_Lutrin]

Thanks so much! Perfect… and simple.