Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date Conversion

Topic Labels: Formulas
859 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.