Dear Group,

I am working on a database which contains a number of personal records one field being date of birth.

I require to flag up all those records where a birthday is within one week, or one month, of the date the search is carried out, so the database user can send a card in plenty of time. I think it might also be useful if the procedure could also flag up those dates which had been missed, so a late card can be sent.

I have started to look at the problem using a query using the DateDiff and DatePart operators, but things are starting to look rather complicated. Does anyone have any ideas?

Cheers.