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

Date_time format not returning correct date

Topic Labels: Formulas
Solved
Jump to Solution
263 2
cancel
Showing results for 
Search instead for 
Did you mean: 

My goal is to have a DOB field concatenate with a name and calculated age field. Currently the concatenate works fine with CONCATENATE(Child_First,", “,Gender,”, ",Age) = Rohnan, Boy, 10M

When I add DOB field I get Rohnan, Boy, 10M, 2020-12-15T00:00:00.000Z
How do I get rid of the T00:00:00.000Z at the end?

When I use the Date_time format I get gibberish. CONCATENATE(Child_First,", “,Gender,”, “,Age,”, ",DATETIME_FORMAT(DOB,‘dd-mmm-yyyy’)) =
Rohnan Boy 10M Tu-000-yyyy
What I want to see is: Rohnan Boy 10M 15-Dec-2020

1 Solution

Accepted Solutions

The format specifiers are case sensitive. Try the format specifier D-MMM-YYYY.

See Solution in Thread

2 Replies 2

The format specifiers are case sensitive. Try the format specifier D-MMM-YYYY.

OMG, that did it thank you very much.