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: [email protected] > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
