You’re a rock star John!
_____ Kind Regards, Carl Wilson From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: 16 September 2015 17:04 To: [email protected] Subject: Re: help in runic ** Funny … I know I answered this before. (I am guessing it was in 1997) … Check this post: http://www.javasystemsolutions.com/arslist/view/52078443 -John On Wed, Sep 16, 2015 at 10:12 AM, Grooms, Frederick W <[email protected]> wrote: ** Yes … If you do some math on the Date or time it converts the value to a number and you can work with it If you work with $TIMESTAMP$ you have to remove the date (The % is the MOD operator so this removes the date and leaves only the seconds past midnight) ((($TIMESTAMP$ - "1/1/70") % 86400) >= (16 * 3600)) Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: Wednesday, September 16, 2015 9:24 AM To: [email protected] Subject: Re: help in runic ** My playing with this stuff before required something like ($TIME$ - 0) > (14*3600) It was the "- 0" that allowed the stuff to happen. -John On Wed, Sep 16, 2015 at 9:17 AM, Reiser, John J <[email protected]> wrote: ** Shouldn’t it be $TIMESTAMP$ > 57600 Thank you, --- John J. Reiser Building 760-J202 Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MST Moorestown Region The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, September 16, 2015 10:00 AM To: [email protected] Subject: EXTERNAL: Re: help in runif ** Try using the number of seconds instead of the string (16 * 3600) Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Luisa Clotilde Carena Sent: Wednesday, September 16, 2015 8:52 AM To: [email protected] Subject: help in runif ** Hi all, I've a filter and i want to run it only after 16:00 o' clock. Can you help me to write the correct Run if? I receive this errors: $TIME$ > "16.00.00" arerror 313 - Incompatible data types for intended relational operation., $TIME$ > "16:00:00" arerror 313 - Incompatible data types for intended relational operation., $TIME$ > "04:00:00 PM" arerror 8957 $TIME$ > 576000 filtre run everytime thank you Luisa Carena _ARSlist: "Where the Answers Are" and have been for 20 years_ -- John Sundberg Kinetic Data, Inc. "Your business. Your process." 651-556-0930 I [email protected] <http://www.kineticdata.com/> www.kineticdata.com I <http://community.kineticdata.com/> community.kineticdata.com _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
