
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2020 02:35 PM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 01, 2020 09:26 PM
adjust your formula like so:
CONCATENATE(Topic," - ", DATETIME_FORMAT({Start Time},"DD-MM-YYYY"))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 01, 2020 09:26 PM
adjust your formula like so:
CONCATENATE(Topic," - ", DATETIME_FORMAT({Start Time},"DD-MM-YYYY"))
