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
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
