using a query to find dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database where I have a start date and end date.. I would like to
be able to have an input date that will be between start date and end date,
but sometimes the end date will be null. Looking for a result of

Input date <= Start date AND >= End date or end date is null.

What I am currently getting arethe correct records except where the end
date is null, I am getting records that do not match the sart date part of
the criteria.

Please help!!
 
try to write it like that

Input date <= Start date AND >= End date or end date is null
(Input date <= Start date) and (Input date >= End date or end date is null)
 
Back
Top