Birthday sort criteria

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
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
 
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:


gives me everything after yesterday.

But this:


does not give me 14 days.

What have I missed?

Thanks,

Robin Chapple
Click to expand...

How about:
=Format(Date(),"mmdd") And <=Format(Date()+14,"mmdd")
Click to expand...
Or ...
Between Format(Date(),"mmdd") And Format(Date()+14,"mmdd")
 
Back
Top