Re: [Emerald] Changing Permanent Expire...

Dale E. Reed Jr. ( (no email) )
Mon, 20 Sep 1999 13:37:03 -0700

David Routh wrote:
> OK, here's another... please correct me if I'm wrong:
> >update masteraccounts
> >set overdue=[new value]
> >where overdue=[old value]
> >
> update masteraccounts
> set paidthru=9/30/1999
> where paidthru=10/1/1999
> Would this set all the MBR's that have a Paid Thru of 10/1/99 to 9/30/99?

Yes, But I would recommend 10/1/99 over 9/30/99.

> What happened is when we started inputting customers into Emerald we set
> the Paid Thru and Expire and Billed Thru dates as 10/1/1999 where we should
> have put them to 9/30/1999 which is what they are actually paid thru...

Its better to go from the 1st, than the last month. Use the 25th if
you want to go from the last of the month.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: