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:[email protected] ARSlist: "Where the Answers Are"

