Just add additional criteria for the date (('Create Date' >= "08/01/2007") AND ('Create Date' < "09/01/2007")) AND ...
If you are doing this in a Macro change "08/01/2007" to "$Start Date$" and "09/01/2007" to "$End Date$" so it will prompt you Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO Sent: Friday, September 14, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: Ticket Reporting - Outside Normal Business Hours (U) UNCLASSIFIED Do you know of a way to wildcard the date so that I can report on all of "last month's" after hours tickets? Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x251 Apparently, there is nothing that cannot happen today. Mark Twain -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 14, 2007 11:42 AM To: arslist@ARSLIST.ORG Subject: Re: Ticket Reporting - Outside Normal Business Hours (U) ** Here is an example All tickets created between 5pm and 7am on any day: (((((( 'Create Date' - "1/1/70") % 86400) >= 17 * 3600) AND ((( 'Create Date' - "1/1/70" ) % 86400) <= 24 * 3600)) OR (((( 'Create Date' - "1/1/70") % 86400) >= 0 * 3600) AND ((( 'Create Date' - "1/1/70" ) % 86400) <= 7 * 3600)))) Fred _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Julie L Kanakanui JLKANAKA Sent: Friday, September 14, 2007 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Ticket Reporting - Outside Normal Business Hours (U) ** "....great searches that will find records based on time criteria and the day piece of the date/time stamp is ignored..." I'd be very interested to hear more about such searches if anyone has any! We need to do this also. Thanks, Julie Kanakanui Remedy Administrator/Developer Information Technology Services University of North Carolina at Greensboro [EMAIL PROTECTED] "Shellman, David" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 09/13/2007 02:03 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Ticket Reporting - Outside Normal Business Hours (U) In the past folks have presented some great searches that will find records based on time criteria and the day piece of the date/time stamp is ignored. Another process that can be used is to set a hidden field using Business Hours rules when the record is Resolved. The process adds 0 seconds to the current time. If it is outside of the business hours the hidden field will not be the same as the Resolved Date field. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO Sent: Thursday, September 13, 2007 1:56 PM To: arslist@ARSLIST.ORG Subject: Ticket Reporting - Outside Normal Business Hours (U) UNCLASSIFIED Our environment - Windows server 2003 ARS 6.3 patch 21 SQL 2000 Help Desk 5.5 SLA 5.5 I need to build a report that will include tickets submitted and/or resolved outside of normal business hours. The "Business Tag" field is of no assistance because it is written to on submit; tickets resolved after normal hours may have been submitted at any time in the past. The "Assigned to Group+" field is of no assistance because any of our techs may provide a service in or out side of normal business hours. Tickets will have been submitted and/or resolved after 1800 and before 0700 daily, Sunday thru Saturday. I have Crystal Reports. Any assistance is appreciated. Thanks. Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x251 Apparently, there is nothing that cannot happen today. Mark Twain _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"