Re: help in runic

2015-09-16 Thread John Sundberg 
thx - I’ll tell my kids - I am sure they will be impressed !

:)

-John

On Wed, Sep 16, 2015 at 6:38 PM, Carl Wilson  wrote:

> **
>
> You’re a rock star John!
>
>
> --
>
>
>
> Kind Regards,
>
>
>
> *Carl Wilson*
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg
> *Sent:* 16 September 2015 17:04
> *To:* arslist@ARSLIST.ORG
> *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 <
> 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 
> 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 ] *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
>
>
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
> _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"

Re: help in runic

2015-09-16 Thread Carl Wilson 
You’re a rock star John!

 

  _  

 

Kind Regards,

 

Carl Wilson

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: 16 September 2015 17:04
To: arslist@ARSLIST.ORG
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 
 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  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] 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 

 <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"

Re: help in runic

2015-09-16 Thread John Sundberg 
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 
> 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 ] *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"

Re: help in runic

2015-09-16 Thread Grooms, Frederick W 
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 
mailto: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<mailto:arslist@ARSLIST.ORG>] On Behalf Of Grooms, 
Frederick W
Sent: Wednesday, September 16, 2015 10:00 AM
To: arslist@ARSLIST.ORG<mailto: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] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG<mailto: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





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: EXTERNAL: Re: help in runic

2015-09-16 Thread Reiser, John J 
Yeah, I jumped the gun
$TIMESTAMP$ > $DATE$ +(16 * 3600)

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 Ken Pritchard
Sent: Wednesday, September 16, 2015 10:19 AM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: help in runic

**
If you use TIMESTAMP wouldn’t you  need to do a calc to remove the date portion.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Wednesday, September 16, 2015 10:17 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: help in runic

**
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<mailto: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] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG<mailto: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_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_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"

Re: help in runic

2015-09-16 Thread John Sundberg 
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 
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 ] *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_
> _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"

Re: help in runic

2015-09-16 Thread Ken Pritchard 
If you use TIMESTAMP wouldn’t you  need to do a calc to remove the date portion.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Wednesday, September 16, 2015 10:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: help in runic

 

** 

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 <mailto: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] On Behalf Of Luisa Clotilde Carena
Sent: Wednesday, September 16, 2015 8:52 AM
To: arslist@ARSLIST.ORG <mailto: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_ 

_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"

Re: help in runic

2015-09-16 Thread Reiser, John J 
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] 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_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"