Probably not. I just needed a quick count so I took a older/simpler search that didn't cross midnight and molded it into what I needed. I could have run the two separate searches and added the counts. But what fun would that have been? :)
On Wed, Nov 7, 2012 at 2:16 PM, Grooms, Frederick W < [email protected]> wrote: > ** > > Since you are doing the MOD (and the time should never be less than 0 or > greater than 86400) do you really need to check for Midnight (< 24 * 3600 > or >= 0*3600) ?**** > > ** ** > > Fred**** > > ** ** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jason Miller > *Sent:* Wednesday, November 07, 2012 4:15 PM > *To:* [email protected] > *Subject:* Re: Query for tickets between 8 PM and 4 AM the following day** > ** > > ** ** > > ** Thanks! That did it.**** > > ** ** > > Any idea why? It seems redundant to me.**** > > ** ** > > Jason**** > > ** ** > > On Wed, Nov 7, 2012 at 2:08 PM, David Durling <[email protected]> wrote:**** > > ** **** > > Jason,**** > > I see what you mean. Try adding an extra set of parentheses around each > part (clause) OR (clause):**** > > ((((((( '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"))**** > > David**** > > David Durling**** > > University of Georgia**** > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jason Miller > *Sent:* Wednesday, November 07, 2012 5:03 PM > *To:* [email protected] > *Subject:* Query for tickets between 8 PM and 4 AM the following day**** > > **** > > ** 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"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
