Months Missed

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

I am trying to design a query in that the due day is in
one field (number) and the trans date is in another. For
example there could be a due day of 21 and i need to find
out which agmts have missed 1, 2, and 3 consecutive
months. have tried various things but no correct answer.
Also tried just using 30 days or bet 31 and 60 days but
this is not correct for some months.

Hope you can help
 
I am trying to design a query in that the due day is in
one field (number) and the trans date is in another. For
example there could be a due day of 21 and i need to find
out which agmts have missed 1, 2, and 3 consecutive
months. have tried various things but no correct answer.
Also tried just using 30 days or bet 31 and 60 days but
this is not correct for some months.
Click to expand...

What does 21 mean in this context? How can you identify the actual
date - August 21, 2002 for instance - from just 21 in the day field?
Is trans date a similar number, or is it a Date/Time field?

I'd suggest storing both dates *AS DATES* - you can then use

DateDiff("m", [due date], [trans date])

to count the months.
 
Back
Top