using a query to find dates

[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!!

 

[Guest]

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)