Help

Short Date in Formula

Topic Labels: Formulas
Solved
Jump to Solution
1290 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jess_Harlee
4 - Data Explorer
4 - Data Explorer

Hi so I’m trying to write a formula to concatenate a name and a date but the date keeps coming back in long format. Is there anyway I can just have the short date (i.e. 09/05/2019) shown?

image.png

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

Hi @Jess_Harlee - when you concatenate the date with something else you turn it into a string and the default format is the full YYYY-MM-DD HH:MM:SS:000Z. You need to format the DATE field using DATETIME_FORMAT()

Screenshot 2019-09-05 at 21.22.32.png

'Some text ' & DATETIME_FORMAT(Date, 'MM-DD-YYYY')

JB

See Solution in Thread

1 Reply 1
JonathanBowen
13 - Mars
13 - Mars

Hi @Jess_Harlee - when you concatenate the date with something else you turn it into a string and the default format is the full YYYY-MM-DD HH:MM:SS:000Z. You need to format the DATE field using DATETIME_FORMAT()

Screenshot 2019-09-05 at 21.22.32.png

'Some text ' & DATETIME_FORMAT(Date, 'MM-DD-YYYY')

JB