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

You'll have to write code. I'm not 100% sure that I understand your question though. In the givin example are your trying to obtain the answer 9/12/01 or are your trying to obtain "Tuesday" or are you looking for something different?

Search help for the DateAdd function.