Date format problem

[Andrew_Mein]

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

[M_k]

Hi @Andrew_Mein

Here is a link that shows all the date formats:

Airtable - Support

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...

Maybe it can help.

Mary K

[Justin_Barrett]

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:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...