I need to do a small date calc. I need to set a field with a value if a
Date field is greater than 36 hours but less than 48. I'm looking at
this
( 'Type' = Normal) AND (( 'Planned Change Date' - $TIMESTAMP$) = ((60
* 60) * 48)) AND (( 'Planned Change Date' - $TIMESTAMP$) = ((60 * 60) *
36))
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Boylan, David
Sent: Monday, October 19, 2009 1:50 PM
To: arslist@ARSLIST.ORG
Subject: Time Calc
**
I need to do a small date calc. I need to set a field with a value if a Date
field
(in which case you
can’t do this anyway).
Lyle
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza
Sent: Monday, October 19, 2009 12:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Time Calc
**
David,
( 'Type' = Normal) AND (( 'Planned Change Date
: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor
Sent: Monday, October 19, 2009 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Time Calc
No, that’s not right. Putting OR will always cause it to be true, because
every date will either be less than
)
[mailto:arsl...@arslist.org]on Behalf Of Joe DeSouza
Sent: Monday, October 19, 2009 2:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Time Calc
**
David,
( 'Type' = Normal) AND (( 'Planned Change Date' - $TIMESTAMP$) = ((60 * 60)
* 48)) OR (( 'Planned Change Date' - $TIMESTAMP$) = ((60 * 60) * 36
: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Lyle Taylor
Sent: Monday, October 19, 2009 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Time Calc
No, that’s not right. Putting OR will always cause it to be true, because
every date will either be less than
No wonder people get frustrated when trying to prepare for a change. I have
been doing some testing on a business time calc we run that determine how
the number of hours from when a service provider arrives at the customer and
when they leave the customer. Have been using this calc for years
7 matches
Mail list logo