(Patting self on back here - I apologize) This comes up every once in awhile -- every time I smile.
I was the orig author of this concept 15 years ago :) (the closest thing I can find to the orig) http://www.mattreinfeldt.com/forums/ubbthreads.php/topics/80043/Re_AW_Requests_by_Time_of_Day Anyway - just off the top of my head -- I wonder if you could do a NOT between 4AM and 8PM ??? -John On Wed, Nov 7, 2012 at 4:02 PM, Jason Miller <[email protected]> wrote: > ** I am trying to run a quick and dirty search of tickets submitted from 8 > PM and 4 AM the following day. I using this query: > > (((((( 'Arrival Time' - "1/1/1970")+3600) % 86400) >= (20 * 3600)) AND > (((('Arrival Time' - "1/1/1970" )+3600) % 86400) < (24 * 3600))) AND > 'Arrival Time' > "5/1/2012" AND 'Arrival Time' < "5/2/2012") *OR *(((((( > 'Arrival Time' - "1/1/1970")+3600) % 86400) >= (0 * 3600)) AND (((('Arrival > Time' - "1/1/1970" )+3600) % 86400) < (4 * 3600))) AND 'Arrival Time' > > "5/2/2012" AND 'Arrival Time' < "5/3/2012") > > I broke it down into two parts. To the left of the *OR* finds 8 PM to > midnight and to the right of the *OR* finds midnight to 4 AM of the > following day. When I run each half separate it returns the expected > results. When I combine the two with the OR I only get results for the > half (8 to midnight). > > I am sure I am missing something simple. Maybe it is time for some > afternoon coffee? Does anybody see my mistake? > > Thanks, > Jason > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- *John Sundberg* Kinetic Data, Inc. "Your Business. Your Process." *Save The Date! *Second Annual KEG (Kinetic Enthusiasts Group) Feb. 25th - March 1st in Denver, CO. For more information click here - KEG<http://www.kineticdata.com/Events/KEG.html> 651-556-0930 I [email protected] www.kineticdata.com I community.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
