But if he uses the time field, and no date, he will get all values in that field throughout the table - I.E Forever. Result will be the zone "18:00-06:00" BUT these do not cross each other.. so the Query should be IMHO something like.. ( ( (($TIME$ >= (3600 * 18) ) and ( $TIME$ <= (3600 * 24)) ) AND ( (($TIME$ >= (3600 * 0) ) and ( $TIME$ <= (3600 * 6)) ) ) two zones are covered right? I cannot test this.. but it seems right to me.. I need to bring up a testbed to play.. just have not had time lately.. busy being retired and all... ;-)
Just a thought here.. Oh, you will get every day's records though.. Records for each and every day.. just within that Time. have fun On Jan 7, 2008 10:06 PM, LJ LongWing (Head) <[EMAIL PROTECTED]> wrote: > ** Robert, > I think you may have Date Fields and Time Fields confused a bit... > > Time Field - Number of seconds since midnight > Date Field - Date, with no regard for the time > > So if he is looking for time...he should used a time field. > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Robert Molenda > *Sent:* Monday, January 07, 2008 6:06 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: need help to figure out $TIME$! > > ** Well, the $TIME $TIMESTAMP and $SERVERTIMESTAMP fields act differently, > based upon the field... and more over execution location... > > Since you are attempting a calculation, I first must _assume_ that you are > doing this in a FILTER, which would result in $TIMESTAMP and > $SERVERTIMESTAMP always being equal. However $TIME in a FILTER I have seen > some oddities with, in older versions of ARS ( 6.3x) > > However I digress as usual... > > If you are ONLY looking for "TIME" then ensure the field you are using is > a "TIME OR DATE" field not a TIME/DATE, because if you are using a Date/Time > or Integer or Char field, $TIMESTAMP / $SERVERTIMESTAMP and $TIME will > result in the full-boat (date + time) > > Now for the oddities in $TIME as "per the book captain"... Date/Time > fieldtype = Full Boat (Date+Time), Time field = Current TIME, and DATE field > = Number of seconds since midnight. > > Please ensure you are using a DATE field in a FILTER and which > version+patch of ARS you are running upon. > HTH > Robert > > > On Jan 7, 2008 6:52 AM, Grooms, Frederick W <[EMAIL PROTECTED]> > wrote: > > > What part of the qualification is not working? i.e. What times fail? > > > > A Quick and dirty cheat would be to negative check the 2nd test > > > > (NOT ( ($TIME$ >= (60 * 60 * 18) ) OR ( $TIME$ < (60 * 60 * 6)) )) > > > > Fred > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Elinore AR > > Sent: Monday, January 07, 2008 5:05 AM > > To: arslist@ARSLIST.ORG > > Subject: need help to figure out $TIME$! > > > > 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" > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"