[Emerald] Big Query....Need Help

Jason Powell ( (no email) )
Fri, 26 Mar 1999 11:05:28 -0800

We are switching to Anniversary billing, and we need to make the following
changes so we can bill our current people correctly. I am not sure what
kind of query I need to run to get these results. Can someone please give
me a hand?

I need all credit card people under the default billing cycle to change the
paid through date from */15/* to */01/*. Also, I need to change the billed
through date from */15/* to */01/* and the expire date from */15/* to
*/05/*. Last, I need to give all of the credit card people permanent 10 day
limit.

*/15/* is any month, and any year. I don't know if it is possible to just
change the day. Or if I have to put a line for every month and year as a
different line statement.

Any help or suggestions would be greatly appreciated.

Thank You,

Jason Powell

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