> 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"