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?
Solved
Short Date in Formula
Best answer by JonathanBowen
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
+18Hi @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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.