Concatenate Due Date with Description

[Julianne_Daltor]

Hello,

I want to have a field that concatenates the Due Date field with the Description field.
It is showing up as this:
2019=05-31T00:00:00.000ZCafaro Service

My formula is:
CONCATENATE({DUE DATE},Description)

We do not have the time format selected in due date, so I’m not sure why it is generating this way.

We would prefer a simplified date be shown in Month/Day/Year and have that displayed in front of the project description.
Thank you!

[JonathanBowen]

Hi @Julianne_Daltorio You need to use the DATETIME_FORMAT() function to get the date into the format that you need. Try this:

DATETIME_FORMAT({Due Date}, 'MM/DD/YYYY') & '-' & Description

(I’ve used the alternative & rather than CONCATENATE() )

JB

[Julianne_Daltor]

JonathanBowen:

DATETIME_FORMAT({Due Date}, ‘MM/DD/YYYY’) & ‘-’ & Description

This was perfect! Thank you so much Jonathan!