I’m trying to use DATETIME_FORMAT to format a date calculated by a formula to the way I want it to be displayed. I have to use DATETIME_FORMAT rather than the settings button because I’m inserting it into an automated email, which defaults to YYYY-MM-DD format instead of the settings.
It seems like this should be possible but I keep getting an error. Here’s my current formula: DATETIME_FORMAT((DATEADD(TODAY(),14, “days”), ‘DD-MM-YYYY’)
The center formula DATEADD(TODAY(),14, “days”) works properly on its own, so I know it’s something about adding the formatting piece.