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 < frederick.w.gro...@xo.com> 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: > arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg > *Sent:* Wednesday, September 16, 2015 9:24 AM > *To:* arslist@ARSLIST.ORG > *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 <john.j.rei...@lmco.com> > 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: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > *Sent:* Wednesday, September 16, 2015 10:00 AM > *To:* arslist@ARSLIST.ORG > *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:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Luisa > Clotilde Carena > *Sent:* Wednesday, September 16, 2015 8:52 AM > *To:* arslist@ARSLIST.ORG > *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 john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
