Date queries

[Sandy]

Help

I am trying to calc the months missed for certain
customers - there is a day due field (number)and a trans
date field but how do i calc 1, 2 months back from the due
day eg 21?

Hope you can help

Sandy

 

[John Vinson]

Help

I am trying to calc the months missed for certain
customers - there is a day due field (number)and a trans
date field but how do i calc 1, 2 months back from the due
day eg 21?

What does 21 mean?

October 21? September 21? Of what year? HOW CAN ACCESS KNOW what you
mean?

What is the date of "two months prior to 21"?

If your due date were stored as a Date/Time field - Oct 21, 2003 -
then you could use the DateAdd function to calculate the two months
back:

DateAdd("m", -2, [DueDate])

would be August 21 if DueDate contained October 21.

But if DueDate contains JUST THE NUMBER 21, then I can't think of any
way for Access, or any other computer program, or any human being to
unambiguously determine the correct date.