Birthday sort criteria

R

Robin Chapple

I have used advice from previous threads to produce a birthday table
listed on day and month numbers.

I am now attempting to add criteria to a query to give me the next 14
days records only.

This:
(Format(Date(),"mmdd"))
Click to expand...

gives me everything after yesterday.

But this:
(Format(Date(),"mmdd")) And <(Format(Date(),"mmdd")+14)
Click to expand...

does not give me 14 days.

What have I missed?

Thanks,

Robin Chapple
 
Top