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 date field displays other data

Topic Labels: Formulas
1254 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ian_james_Dunca
5 - Automation Enthusiast
5 - Automation Enthusiast

I am wondering if anybody knows a way to change the way the field for date created is displayed in concatenate? This formula reveals the date as follows:

2021-10-29T20:28:27.000Z - Task Detail - Task Assigned to - Projects

I am looking for something a little cleaner like:

2021-10-29 - Task Detail - Task Assigned to - Projects

IF(Projects = BLANK(),“No Project”,CONCATENATE("",{Date created}," - “,{Task Detail},” - “,{Task Assigned to},” - ", Projects))

cheers!

1 Reply 1

Hi @Ian_james_Duncan

You can wrap the reference to {Date created} in your formula in this:

DATETIME_FORMAT({Date created}, 'YYYY-MM-DD')

You can play with the formatting string to get exactly what you want by referencing your options here: