Don't know why (It's the geek in me) but I had to try it. I did this against the incident form:
'Submit Date' >= $DATE$ - 60*60*24*31 AND ((( 'Submit Date' - "1/1/1970") % 86400) <= (6 * 3600) OR (( 'Submit Date' - "1/1/1970" ) % 86400) > (18 * 3600)) When I looked at the actual results I had to use 6*3600 and 18*3600 Thanks, Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Friday, September 16, 2011 11:46 AM To: [email protected] Subject: Re: Advanced Search Query 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:[email protected]] On Behalf Of Grooms, Frederick W Sent: Friday, September 16, 2011 10:36 AM To: [email protected] 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:[email protected]] On Behalf Of hcmdr5 Sent: Friday, September 16, 2011 10:05 AM To: [email protected] 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
