Sep 16, 2023 03:19 PM
Trouble with date formula: September 14, 2023 + Coaching=Coaching 2023-09-16T04:00:00.000Z.
The date always comes out wrong in the Concatenation.
Sep 18, 2023 07:11 AM
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.)
