Calculating A Past Date

[jcruzAME]

All the functions I've looked up deal with having both dates and calculating a difference.

Is there way to calculate a date in the past?

For example, if you need to calculate 30, 60, 90 or even 365 days back from today.

 

[pr2-eugin]

Use DateAdd function with a negative value.. Like.. DateAdd("d",-10,Date) will give you 02/07/2012

 

[jcruzAME]

Awesome, thanks!

 

[pr2-eugin]

You are welcome..