If you move the expire dates back, then you must void the invoice for
that customer that overlapps, or they will not be re-dilled (this, you
You can do this, but its not going to make sense afterwards (that
probably doesn't matter). What you want to do is something like this:
Update Invoices Set EndDate = DateDiff(Day, 0-10, EndDate)
Where EndDate > 'x/x/x' and EndDate < 'y/y/y/'
That will move the invoices for that period back ten days.
Then you can do the same for the accounts:
Update MasterAccounts Set maExpireDate = DateDiff(Day, 0-10,
Where maExpireDate > 'x/x/x' and maExpireDate < 'y/y/y/'
Your invoices won't be accurate after this, but I think it will do
what you want. Always make a backup before doing anything like this.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com