Calculating a Date only Field

2008-01-30 Thread Kemes, Lisa
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'

Re: Calculating a Date only Field

2008-01-30 Thread Grooms, Frederick W
To: arslist@ARSLIST.ORG 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

Re: Calculating a Date only Field

2008-01-30 Thread Thomas Bean
! --Thomas - Original Message - From: Grooms, Frederick W Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, January 30, 2008 10:52 AM Subject: Re: Calculating a Date only Field ** A Date field (not a Date/Time that displays just the date

Re: Calculating a Date only Field (correction)

2008-01-30 Thread Thomas Bean
): 'Expiration Date' = 'zTmpDate' --Thomas - Original Message - From: Thomas Bean To: arslist@ARSLIST.ORG Sent: Wednesday, January 30, 2008 11:35 AM Subject: Re: Calculating a Date only Field Fred, This won't work in a search qualification, because the $DATE$ keyword