Can someone tell me is there a way to create a query that shows my breaches by the date they expired.
Currently I have a query that allows a user to select a Company and a date range that is currently the Creation Date. The issue I have is that each month the query is used to show any breaches during that month. The incident may be logged in that month but breached the following month so therefore currently wouldn't be shown in the query unless you over lap the dates.
Is there a field or something I should use that when the user runs the query it uses the date of the IsBreach instead of when the incident was created.