Birthday sort criteria

[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"))

gives me everything after yesterday.

But this:

(Format(Date(),"mmdd")) And <(Format(Date(),"mmdd")+14)

does not give me 14 days.

What have I missed?

Thanks,

Robin Chapple

 

[fredg]

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

How about:

=Format(Date(),"mmdd") And <=Format(Date()+14,"mmdd")

Or ...
Between Format(Date(),"mmdd") And Format(Date()+14,"mmdd")

 

[Robin Chapple]

Thanks Fred,

Success! <G>

Robin Chapple

How about:
Or ...
Between Format(Date(),"mmdd") And Format(Date()+14,"mmdd")