Help

CONCATENATE formula returning strange date format

Solved
Jump to Solution
1253 1
cancel
Showing results for 
Search instead for 
Did you mean: 
PJ_Saysell-Rosa
4 - Data Explorer
4 - Data Explorer

I am setting up a conference planner and want the name of a meeting to be the Topic + Date.

The formula I am using is:

CONCATENATE(Topic," - ",{Start Time})

This works, however it formats the date as YYYY-MM-DD and puts alphabet characters in with the time. (see picture)

How can I format this so that it only shows the date, preferably in DD-MM-YYYY format? I need to keep the time field on the record so that it shows what time the conference will start.

Thank you!

Airtable Formula

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

adjust your formula like so:

CONCATENATE(Topic," - ", DATETIME_FORMAT({Start Time},"DD-MM-YYYY"))

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

adjust your formula like so:

CONCATENATE(Topic," - ", DATETIME_FORMAT({Start Time},"DD-MM-YYYY"))