No, that’s not right. Putting OR will always cause it to be true, because every date will either be less than 48 hours in the future or greater than 36 hours in the future. It should stay AND. It looks correct to me with AND so long as it’s a Date Time field and not just a Date field (in which case you can’t do this anyway).
Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Monday, October 19, 2009 12:25 PM To: [email protected] Subject: Re: Time Calc ** David, ( 'Type' = "Normal") AND (( 'Planned Change Date' - $TIMESTAMP$) <= ((60 * 60) * 48)) OR (( 'Planned Change Date' - $TIMESTAMP$) >= ((60 * 60) * 36)) would cut it.. With AND instead of OR you will get no results to set your Type field as the result will always be FALSE.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Boylan, David Sent: Monday, October 19, 2009 1:50 PM To: [email protected] Subject: Time Calc ** 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)) Then do my set field. Planned Change Date is a date in the future. Am I close? ☺ Thanks, Dave _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
