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.

How do I concatenate two date fields?

3200 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Katelynn_Straw1
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

4 Replies 4

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.

Here’s a copy-paste safe version of @kuovonne’s formula:

DATETIME_FORMAT({Estimate Start Date}, 'MMDDYY') &
"-" &
DATETIME_FORMAT({Estimated Completion Date}, 'MMDDYY')
Katelynn_Straw1
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you both!! I have never used & and wasn’t sure where exactly to put the DATE_FORMAT on my concatenate.

erinhorn12
4 - Data Explorer
4 - Data Explorer

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? 

DATETIME_FORMAT({Date PL NT}, 'L') & '-' & DATETIME_FORMAT({Date of PL Local Orders}, 'L')