>set overdue=[new value]
>where overdue=[old value]
Would this set all the MBR's that have a Paid Thru of 10/1/99 to 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...
Basically, I'd like to change all the Paid Thru, Expire and Billed Thru
that are 10/1/1999
Thanks, still learning...
For more information about this list (including removal) go to: