Help

Date format problem

Topic Labels: Formulas
1429 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Mein
4 - Data Explorer
4 - Data Explorer

I have a sheet where
interaction type field is a Single Select list
Date of Interaction field is a date

The following formula returns a date in the format 2019-11-05T00:00:00.000Z

IF({Interaction Type} = “Meeting”,{Date of Interaction}," ")

How can I get the date just to show as 05/11/2019

2 Replies 2
M_k
11 - Venus
11 - Venus

Hi @Andrew_Mein

Here is a link that shows all the date formats:

Maybe it can help.

Mary K

Welcome to the community, @Andrew_Mein! :grinning_face_with_big_eyes: To expand on what @M_k posted, referencing a date field in a formula simply pulls in the raw underlying datetime object from the referenced field. Airtable doesn’t assume anything about how you want that to be formatted, so it defaults to a pretty raw display of the data. To clean it up, you’ll need to wrap that field reference inside a DATETIME_FORMAT() function. The link that @M_k shared contains details on the format specifiers needed by that function, but not necessarily a rundown of the function syntax. For that, bookmark this page: