Creating a Constituent List of a Status that is 90+ days Past Due

Chris Zello

I see it is possible in web view to create a Constituent List with a Prospect Status = Qualification.  But I'm wondering if I can further filter to specify the number of days that the Status is past due?


For example, I'd like to create a Constituent List of everyone in Qualification who is 90+ days in this status.


I'm not sure if this is somehow tied to a Tag?


Thanks.

Chris Zello

I checked with Support, and they said this is not possible in web view. There is no filter for number of days the Status is past due. Classification and Status are available.


This can be done in Database View, using the Proposals "Date Expected" field, and then Prospect Status. Making this a static query would then allow it to be found in Constituent Queries. Unfortunately in web view there does not appear to be a way to display a column showing the # of days past due.