Time Calc

2009-10-19 Thread Boylan, David
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))

Re: Time Calc

2009-10-19 Thread Joe DeSouza
  -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

Re: Time Calc

2009-10-19 Thread Lyle Taylor
(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

Re: Time Calc

2009-10-19 Thread Bill Myers
: 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

Re: Time Calc

2009-10-19 Thread Joe DeSouza
) [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

Re: Time Calc

2009-10-19 Thread Joe DeSouza
: 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

DST - Difference between 5.1.2 and 7.0 on Business Time calc

2007-03-01 Thread Susan Palmer
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