Re: [Emerald] Extend Accounts

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Previous message: Kelly Wright: "[Emerald] Extend Accounts"
Next message: Brad Teague: "RE: [Emerald] Extend Accounts"

Peter Deacon ( peterd@iea-software.com )
Fri, 2 Apr 1999 05:59:02 -0800 (Pacific Standard Time)

On Fri, 2 Apr 1999, Kelly Wright wrote:

> Can anyone help me with a sql script to extend all accounts. Thanks.

These two will extend anyone expiring between April 1st and April 30th
another 30 days.

UPDATE MasterAccounts SET Extension = Extension + 30
WHERE DATEADD(dd,Extension+OverDue,maExpireDate) BETWEEN 'April 1 1999'
AND 'April 30 1999'

UPDATE SubAccounts SET Extension = Extension + 30
WHERE DATEADD(dd,Extension,saExpireDate) BETWEEN 'April 1 1999'
AND 'April 30 1999'

Have Fun!
Peter

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html