Criteria issue for limiting a query

[Antavas]

I have built a query1 that allows me to enter a date range for when an issue
is opened. I then built another query2 off of that one using these criteria:

<[Please Enter Prior Date] and >[Please Enter Post Date]

My goal is to have this query return all issues opened before the date range
I specify in query1 and that did not close before the end of that date range.
It does work except that will only return the items that have a closed date.
It won't capture the ones that remain open and do not have a close date. What
can I do to modify this criteria: >[Please Enter Post Date] under the closed
date so that it returns everything I need?

 

[KARL DEWEY]

Try this --
<[Please Enter Prior Date] and >[Please Enter Post Date] OR Is Null

I prefer using --
Between [Please Enter Prior Date] and [Please Enter Post Date] OR Is Null
as it includes the date entered also when they do not have time associated
with them.

 

[Antavas]

Thanks! It worked!

Try this --
<[Please Enter Prior Date] and >[Please Enter Post Date] OR Is Null

I prefer using --
Between [Please Enter Prior Date] and [Please Enter Post Date] OR Is Null
as it includes the date entered also when they do not have time associated
with them.
--
KARL DEWEY
Build a little - Test a little

I have built a query1 that allows me to enter a date range for when an issue
is opened. I then built another query2 off of that one using these criteria:

<[Please Enter Prior Date] and >[Please Enter Post Date]

My goal is to have this query return all issues opened before the date range
I specify in query1 and that did not close before the end of that date range.
It does work except that will only return the items that have a closed date.
It won't capture the ones that remain open and do not have a close date. What
can I do to modify this criteria: >[Please Enter Post Date] under the closed
date so that it returns everything I need?