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

 

[scottk]

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?

 

[Jack Cowley]

Search help for the DateAdd function.