How to only add Start Date?

[Kelly_Smy]

Hello, can someone help me figure out how to add ONLY the Start Date to a field? Currently, it is adding both the Start Date and Start Time. See images for my current formula. Thank you!

[Jeremy_Oglesby · Accepted solution]

Hi @Kelly_Smy

Take a look at the DATETIME_FORMAT() function here:

Airtable Support

Formula field reference

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

And the format specifiers you can use with it 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...

You’ll just wrap the {Start Date/Time} part of your formula in the DATETIME_FORMAT() function.

It might be worth noting that you can simplify your CONCATENATE() formula can be simplified a bit by combining the literal string parts; ie,
" ", "-", " ",
could become just
" - ",

[Kelly_Smy]

Thank you for that information. I hate to sound like a complete noob but I don’t quite understand when you that “I’ll just wrap the {Start Date/Time} part of your formula in the DATETIME_FORMAT() function”?

I tried adding the "DATETIME_FORMAT(‘YYYY/MM/DD’) after the {Start Date/Time} string but it came back with an #ERROR in the property field. I’m not sure where the DATETIME_FORMAT needs to go?

[Kelly_Smy]

I fixed it, it worked. Thank you so much!