Last modified date is not a great date to work off as any changes to the ticket will cause it to update. If you want to go by when the ticket has been resolved/cancelled, if you're using version 7.x and above, last resolved date would be a good date to work off of. Otherwise, you'll need to create a datetime field and have a filter set it when the ticket is resolved or cancelled. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701
>>> [email protected] 05/20/10 8:01 PM >>> ** I am attempting to build a flashboard with the following criteria - 1.) Incidents that are Resolved, Closed or Cancelled 2.) User defined Date range on a Display Only form - Last Week or Last Month 3.) Only Incidents from Helpdesk or Desktop Support The issues I am having are with the Date range for Last Month: 1.) If I search for 4/1 - 4/30, the returned results bring back Incidents from 5/1 2.) The Flashboard brings back Incidents resolved from 3/23, due to we have Incident Rules to Auto Close in 10 days from the Resolved Status and AR Escalator is the one who modified this Incident Anyone have a flashboard with the similar Criteria? How have you overcome this Last month mayhem? Is there a true Qualification to get the Last Month of Incidents? I'm having trouble finding the proper qualification. I have also tested with Resolved.TIME instead of Last Modified Date; however the flashboard is blank when I use this. Here is the current Customqual I have defined in the Active link to set the criteria- (((((((((((((((((("customqual='Status' >=" + """") + "Resolved") + """") + "AND 'Assigned Group' =") + """") + "HelpdeskSG") + """") + "OR 'Assigned Group' =") + """") + "DesktopSG") + """") + "AND 'Last Modified Date' >=") + """") + $SDate2$) + """") + "AND 'Last Modified Date' <=") + """") + $EDate2$) + """" SDate2 and EDate2 are Date fields on the Display Only with the Flashboards. Any Help is appreciated. Thanks in advance, Andre _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
