Help

Format Synced Field as Date Time

Topic Labels: Sync
375 7
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a date time field being sync’d from another base and I need to reformat that MM-DD-YYYY HH:MM into a true date time format from the string it comes in as, as a sync’d field.

Any ideas?

7 Replies 7

Create a formula field and use DATETIME_PARSE({your synced date time field})

This will cause the formula field to register as a date field, and you can use the Format tab in the formula field to select the format of the date and time.

If you need more customized formatting, you can wrap the above formula inside a DATETIME_FORMAT() function. This gives you a huge amount of customizability for how to show the result. And the use of the DATETIME_PARSE() function will allow Airtable to see and treat the result as a date for the purposes of sorting, filtering, etc.

That is exactly how I set it up.

See attached and I get an error.

Screen Shot 2021-05-28 at 8.46.45 AM

Try using the DATETIME_PARSE() function without any arguments (just the variable itself inside the parentheses).

Still an error.

DATETIME_PARSE({New Meeting Day/Time (from Link to Updates) 2})