Short Date in Formula

[Jess_Harlee]

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?

[JonathanBowen · Accepted solution]

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()

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

JB