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: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 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? J Thanks, Dave _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
