how to get a date of past time

[SKV]

Hi,

I want to get a date 4 weeks back from a said date. So if I have a date of April 15, I should get output as March 15.

Please suggest the method to get this output.

Thanks
Sachin

 

[Ethvia]

There are probably many ways, but here's one:

14 days ago: (Now())-14

so this is taking the current date and time and subtracting 14 days...you can make it any number of days you want.

 

[SKV]

Just got a better way to do it. - use dateadd()

There are probably many ways, but here's one:

14 days ago: (Now())-14

so this is taking the current date and time and subtracting 14 days...you can make it any number of days you want.

 

[Ethvia]

took me a minute to figure out how on earth DateAdd() would give you a date 1 month ago...but I supposed if you specify a negative number then it would.