
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2019 01:02 PM
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! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2019 01:25 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 05, 2019 01:25 PM
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
