Concatenate date field displays other data

[Ian_james_Dunca]

I am wondering if anybody knows a way to change the way the field for date created is displayed in concatenate? This formula reveals the date as follows:

2021-10-29T20:28:27.000Z - Task Detail - Task Assigned to - Projects

I am looking for something a little cleaner like:

2021-10-29 - Task Detail - Task Assigned to - Projects

IF(Projects = BLANK(),“No Project”,CONCATENATE("",{Date created}," - “,{Task Detail},” - “,{Task Assigned to},” - ", Projects))

cheers!

[Jeremy_Oglesby]

Hi @Ian_james_Duncan

You can wrap the reference to {Date created} in your formula in this:

DATETIME_FORMAT({Date created}, 'YYYY-MM-DD')

You can play with the formatting string to get exactly what you want by referencing your options here:

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 format of DATETIME_FORMAT(Datetime, 'format sp...