Historical Req status on a given date/time period
SummaryHistorical Req status on a given date/time period
I need to create a report which can provide all open Reqs on a give date in past. I have taken filter on 'Req Historical Status' as 'Open' but not sure which date field should be used in filter/prompt.
If I use 'Req Historical Status Start Date', it would only return the Reqs which were moved to Open status on those dates. But I need all the Reqs which were already in open on that date.
Any thoughts ?