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