Calculate Previous Date by Subtracting Given Month

[utdel]

Need help you Access Gurus,

I need to find a way to calculate a previous date base on a given date and the number of months to go back to. Example:
what date was it 2 months ago as of 11/12/2001?

It there an Access function to do this or do I need to write some code? Either way if anyone has done this before please fill me in on how to do it.

Thanks in Advance.
Del

 

[simongallop]

DateAdd("m",-2,"11/12/01")

ie (Period,+ or -, Date to calculate from)

 

[Rich]

If you are using a specific date then you need to enclose the date with pounds not quotes. #01/01/01#