Create a filter to find incidents should be resolved

Question

Good afternoon, I need to generate a filter that tells me the incidents that are overdue. That is, the END DATE date is less than the day.
I tried with this filter, but it is not working for me:

project = OCLTP AND resolution = Unresolved and "End Date" < now() ORDER BY priority DESC, updated DESC

We use end-date to set the date by which the incident should be resolved. I want to search for incidents past that date.

Thanks!

Walter Buggenhout · Accepted Answer

Hi @Cristian Peque and welcome to the Community

There does not seem to be very much wrong with that filter. Maybe it does not work as expected because your end date does not have a time value included. You could try this alternative instead:

project = OCLTP AND resolution = Unresolved and "End Date" < StartOfDay()

Hope this helps!