Help

Using a formula calculated date and DATETIME_FORMAT

Topic Labels: Formulas
Solved
Jump to Solution
717 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Anne_Gonzalez
4 - Data Explorer
4 - Data Explorer

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.

Is it possible to do this in one formula?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

I’m not at my computer right now, but I think that should work. I would check to make sure that you’re using straight quotes, not stylized quotes.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

I’m not at my computer right now, but I think that should work. I would check to make sure that you’re using straight quotes, not stylized quotes.

Anne_Gonzalez
4 - Data Explorer
4 - Data Explorer

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”)