Skip to main content

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.

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

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.

Reply


Terms & Conditions