A Date field (not a Date/Time that displays just the date) should be : 'Expiration Date' = ($DATE$ + 30) Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, January 30, 2008 10:26 AM To: [email protected] Subject: Calculating a Date only Field I know how to calculate when something is going to expire in 30 days if the field is a Date/Time field. But what about just a Date field? Here's how I would figure it out it if it was a Date/Time field: ( 'Expiration Date' >= ($DATE$ + (((30 * 24) * 60) * 60))) AND ( 'Expiration Date' < ($DATE$ + (((31 * 24) * 60) * 60))) Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
