This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
Could you use the trigger “at a scheduled time” instead? So, at a scheduled time (say, every day at 9 am), it would check to see if there are any records that match your conditions and then send the email?
I haven’t personally done this, but I think ...
Thanks! I guess that was it. I entered it again, in the same way I swear I’ve entered it previously, but it works now.
Here’s the final product:
DATETIME_FORMAT(DATEADD(TODAY(),14, “days”), “MM-DD-YYYY”)
