Yes, the definitely helps, I completely forgot about the beginning of
Epoch time. Thanks for the great suggestions.
Kyle
Lucero, Michelle - IST contractor wrote:
Hi, Kyle:
I love this stuff. I guess cause I love numbers.
Finds Cases Created between 5:00 PM and 8:00 AM of any day of any year
since Jan 1 1970.
You must use an OR statement, because items cannot be created after 5 PM
and before 8:00 AM at the same time.
(('Arrival Time' - "1/1/1970 12:00:00 AM")%86400) >= (17*3600) OR
(('Arrival Time' - "1/1/1970 12:00:00 AM")%86400) < (8*3600)
You can do the same thing for days of the week, too. When building
qualifications to find items that were created on certain days, don't
forget that Jan 1, 1970 was a Thursday. Meaning the day number for
Thursday in this qual will always be zero.
Finds items created on Thursday and Friday of any week of any year since
January 1, 1970.
((('Arrival Time' - "1/1/1970 12:00:00 AM")%(7 * 86400)) >= (0 * 86400))
AND ((('Arrival Time' - "1/1/1970 12:00:00 AM")%(7 * 86400)) < (2*
86400))
Hope that helps. Obviously, you might want to add more criteria to
narrow your searches.
Michelle
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley
Sent: Friday, August 18, 2006 1:21 PM
To: [email protected]
Subject: Number of Cases Created After Hours
I am trying to figure out a query that will allow me to see, for a
specific site, all cases that were created between 5:00 pm - 8:00 am. I
know how to do this for a specific date using the $DATE$ keyword, but
how might this be done over a extended date range?
This is query I used for a specific date:
(('Arrival Time' >= (( "08/17/2006" - ( 60*60*24 ) + (60*60*17))) AND
(Arrival Time' <= (( "08/17/2006" + ( 60*60*24 ) - (60*60*16))))))
ARS 6.3
Helpdesk 5.5
Thanks
Kyle
--
Kyle Whitley
IT System Support Professional
Office of Information and Instructional Technology (OIIT)
Board of Regents of the University System of Georgia
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
