Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Concatenate Due Date with Description

Topic Labels: Formulas
680 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

2 Replies 2

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

Screenshot 2019-05-20 at 16.06.57.png

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

JB

This was perfect! Thank you so much Jonathan!