Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Short Date in Formula

Topic Labels: Formulas
Solved
Jump to Solution
1804 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