Query by general date range?
jeffschamberger Sep 5, 2014 8:30 AMI need to write a few queries to see open incidents by date range (nonspecific). I'm looking to do the following:
Open Incidents 4 days or less
Open Incidents 5-9 days
Open Incidents 10-14 days
Open Incidents 15-19 days
Open Incidents 20-29 days
Open Incidents 30+ days
I was able to write the first one using the following criteria:
Lifecycle equal to (Process)
Status.Is End is Equal to (False)
Creation Date Is Within the Next (4 days)
And the last one using:
Lifecycle equal to (Process)
Status.Is End is Equal to (False)
Creation Date is Older than (30 days)
I was hoping I could write the others by also using Creation Date is Less than (XX Days) and just adjust the numbers from there but Less Than pulls up a specific date when I pull up the criteria and does not let me select a general number like the Older than criteria does.
Does anyone know of a way or other criteria that can be used to accomplish the other queries? Thank you in advance for your help!