Help

Date Conversion

Topic Labels: Formulas
1682 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dean_Lutrin
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

2 Replies 2

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')

53

JB

Thanks so much! Perfect… and simple.