Help

Date_time format not returning correct date

Topic Labels: Formulas
Solved
Jump to Solution
1125 2
cancel
Showing results for 
Search instead for 
Did you mean: 
RJ_Southam
6 - Interface Innovator
6 - Interface Innovator

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
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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

OMG, that did it thank you very much.