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?
1 Solution
Accepted Solutions
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
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
