Re: Help with date query

2005-02-04 Thread SGreen
Jack Lauman <[EMAIL PROTECTED]> wrote on 02/04/2005 11:57:37 AM: > I want to run a nightly cron job where you iterate throught each row of > a single table and reset a field depending on the conditions specified. > In this case I want to take a date field (RenewalDate) and compare it > to the

Help with date query

2005-02-04 Thread Jack Lauman
I want to run a nightly cron job where you iterate throught each row of a single table and reset a field depending on the conditions specified. In this case I want to take a date field (RenewalDate) and compare it to the current date less a 30 day grace period and if true reset the (Subscripti