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!
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.