help with a query

[Caglar]

Hi all;
I was trying to use the filter function for a small
database. and when i was playing around to find what i was
looking for I realized that I can also use query as a
filter. I need help with the particular select statement.
I am trying to filter out the expiration dates that are
within two days. how can I determine the where clause to
give me that particular result. date format is to be
mm/dd/yyyy.
any help is appreciated and welcome.
regards

Caglar

 

[Ashby]

Try this as a criteria for the date field.

Between Date() And Date()+2

 

[Ashby]

As long as it is a date field it should not make a
difference.