A
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?
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?