Hi,

I have created a new variable in the format of
{DATEFORMAT(yyyy-MM-dd)} which outputs 2011-03-31

I want to incorporate this into an SQL script (below), but I would like to take away 2 from the current date so I can use it to clean up files older that 2 days.

So in the case above I would like the variable to output 2011-03-29

Is this possible or should I be doing it another way?

Thanks in advance!

{DATENOWADD(Days|-2|yyyy-MM-dd)}

---

Thanks for the quick reply!

Although, happen I had scrolled down the list a bit more I would have worked it out myself!

Oops 😊