That makes sense. I’m used to Excel, which sees a date as an integer (irrespective of how its display is formatted.) Your post helps me understand better how Airtable uses CONCATENATE. However, my input column IS in MM/DD/YYYY format, so I’m still st...

Trying to convert a DOB to Birthday. Using the CONCATENATE formula above, my output is giving year of birth, dash, current year with a zero in front. e.g. 1964-02017 . I’m trying to find more instruction on the CONCATENATE command, but coming up blan...

+1 for this. For example, my iPhone allows me to list names as Last, First or First Last; it separately lets me sort by Last or First. Very necessary!