
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 20, 2020 12:35 PM
I have a table with one field for start date and one field for end date. These dates are looked up from another table. I want to have a field that shows a concatenate of the two.
Here is what I have:
CONCATENATE({Estimated Start Date},"-",{Estimated Completion Date})
This is what it’s returning
2020-02-24T00:00:00.000Z-2020-02-29T00:00:00.000Z
I want it to look something like, MMDDYY-MMDDYY
Thanks for any assistance you provide!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 20, 2020 12:42 PM
You need to use a formula to format the date:
DATETIME_FORMAT({Estimate Start Date}, 'MMDDYY') & "-" & DATETIME_FORMAT({Estimated Completion Date}, 'MMDDYY')
I find using the &
operator to join strings to be easier to read than the Concatenate formula.
eta: Converted curly quotes to straight quotes. I originally typed the example on my phone where formatting was more difficult.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 20, 2020 12:47 PM
Here’s a copy-paste safe version of @kuovonne’s formula:
DATETIME_FORMAT({Estimate Start Date}, 'MMDDYY') &
"-" &
DATETIME_FORMAT({Estimated Completion Date}, 'MMDDYY')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 20, 2020 12:50 PM
Thank you both!! I have never used & and wasn’t sure where exactly to put the DATE_FORMAT on my concatenate.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 10, 2023 11:41 AM
I am trying to join these two that use Dates in the field. I know I need to use the DATE_FORMAT but when I put the formula together it returns an #ERROR code. What am I doing wrong?
