Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Oct 29, 2021 02:09 PM
I am wondering if anybody knows a way to change the way the field for date created is displayed in concatenate? This formula reveals the date as follows:
2021-10-29T20:28:27.000Z - Task Detail - Task Assigned to - Projects
I am looking for something a little cleaner like:
2021-10-29 - Task Detail - Task Assigned to - Projects
IF(Projects = BLANK(),“No Project”,CONCATENATE("",{Date created}," - “,{Task Detail},” - “,{Task Assigned to},” - ", Projects))
cheers!
Oct 29, 2021 02:58 PM
You can wrap the reference to {Date created}
in your formula in this:
DATETIME_FORMAT({Date created}, 'YYYY-MM-DD')
You can play with the formatting string to get exactly what you want by referencing your options here: