Hi all,
This is a question about lists - in my past life in the Raiser's Edge I used to be able to select when a date (say, on a step in this case) was blank. So I could build a list to double check on Report Submission Steps due in this date range with a completed date that is blank.
What the best way to build a list to check work in this way? Or is there a canned report I could be using? Currently our reports are unable to only show us those with incomplete completed dates.
Thank you!
To put the issue another way (assuming I am understanding correctly), it is not possible to filter standard date criteria elements by a NULL value. It is possible to define a custom criteria that would accomplish this — it could look something like Step Date Null | In | Yes/No. Note that the data type for the element would be a dropdown, not a date.
Without defining a custom criteria, it may be possible to accomplish the same thing by using multiple lists. In the list where you are trying to filter out records that DO have a date, you would use a List | Does Not Have | <sub-list>, and then in the sub-list, you would define criteria that includes all step records with any date at all (Step Date | >= | 00/00/0000).