searching between dates

  • Thread starter Thread starter He cries for help
  • Start date Start date
H

He cries for help

I have a query that I need a formula that will allow me to search for a date
i.e. all dates between 03-01-08 and 03-23-08. This will allow me to search
for all items in ny
data base that will become date sensiitive during a date span.
 
I have a query that I need a formula that will allow me to search for a date
i.e. all dates between 03-01-08 and 03-23-08. This will allow me to search
for all items in ny
data base that will become date sensiitive during a date span.
Click to expand...

Use a criterion on the date field of
= CDate([Enter start date:]) AND < DateAdd("d", 1, CDate([Enter end date:]))
Click to expand...

The DateAdd stuff is to cover the case that you may have a time portion in
your datefield.
 
Back
Top