It has to be OR in the second one as the two time frames are mutually exclusive: From 6 PM to Midnight (64800 to 86399) and from midnight to 6 AM (0 to 21600). The TIME parameter doesn't "wrap" days.
Just curious: Did you try reversing the conditionals like so? ($TIME$ < (60 * 60 * 18)) AND ($TIME$ >= (60 * 60 * 6)) Not sure why it would make a difference but I've seen stranger things... ... like platypuses. :) J.T. Shyman Column Technologies -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Ponzo Sent: Monday, January 07, 2008 8:48 AM To: [email protected] Subject: Re: need help to figure out $TIME$! One observation - your first qualification uses AND, your second uses OR. Rick Ponzo Elinore AR wrote: > can any of you folks help me? > > i am trying to test $TIME$ if it falls between 06:00-18:00 CST (server > is in CST) > > this is the qualification i am using: > > ( ($TIME$ >= (60 * 60 * 6)) AND ($TIME$ < (60 * 60 * 18)) ) > > and it's not working! > > when i try to reverse the qual to test if $TIME$ is between > 18:00-06:00 CST like this: > > ( ($TIME$ >= (60 * 60 * 18) ) OR ( $TIME$ < (60 * 60 * 6)) ) > > it works just fine. > > what's wrong with the 1st qualification? > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
