I just re-read and realized that hcmdr5 was looking for the opposite hours so just swap the >= and the < in the query
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, September 16, 2011 10:36 AM To: arslist@ARSLIST.ORG Subject: Re: Advanced Search Query Try the following ( ((( $Create Date$ - "1/1/1970") % 86400) >= (7 * 3600)) AND ((( $Create Date$ - "1/1/1970" ) % 86400) < (19 * 3600)) ) Description of above qualification: (This gives you >= 7:00 AM and < 7:00 PM) What this is doing: Subtract off the start of time to convert Remedy value to an integer (if you don't do this ARS tries to work with the value as a string). Use the Modulus "%" (remainder after division) of number of seconds in a day (86400) to get the number of seconds since Midnight. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of hcmdr5 Sent: Friday, September 16, 2011 10:05 AM To: arslist@ARSLIST.ORG Subject: Advanced Search Query Using the Advanced Search is there a way to retrieve all the requests that were created within a certain time interval, for example, between the times of 7 PM and 7AM for the past month. This is needed to find out how many tickets were created after hours. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
