Help

Formula Problem

Topic Labels: Formulas
306 1
cancel
Showing results for 
Search instead for 
Did you mean: 
drrashon
4 - Data Explorer
4 - Data Explorer

Trouble with date formula: September 14, 2023 + Coaching=Coaching 2023-09-16T04:00:00.000Z.

CONCATENATE({Mtg Type} & ' ' & {date test})

The date always comes out wrong in the Concatenation.

1 Reply 1

You can use the DATETIME_FORMAT function to get the date formatted the way you want.

{Mtg Type} & ' ' & DATETIME_FORMAT({date test},'YYYY-MM-DD')

You can find a full list of format specifiers here: https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format

(Also, to join elements, you just need either "&" or the CONCATENATE() function (with commas between elements), just two ways to do the same thing.)