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.
+17You 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.)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.