Fred, You also need to account for DST. I added 3600 to the date calculation. And lose the $, they should be ' for the Advanced Search bar.
('Create Date' > "08/01/2011 AND 'Create Date' < "09/01/2011" AND
( ((( ( 'Create Date' - "1/1/1970")+3600) % 86400) >= (7 * 3600))
AND
((( ( 'Create Date' - "1/1/1970" )+3600) % 86400) < (19 * 3600)) ) )
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me
-----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: EXTERNAL: 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"
smime.p7s
Description: S/MIME cryptographic signature
