Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

CONCATENATE formula returning strange date format

Solved
Jump to Solution
1776 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"))