Modify Next Bill Date

[Ivan Kohler]

You'll need to know how to use your mysql client, be it mysql, dbimon,
xmysql or whatnot.

You'll need to know SQL, here's a good quick reference: 
http://w3.one.net/~jhoffman/sqltut.htm

You'll need to know how Freeside stores dates.  See
htdocs/docs/man/cust_pkg.txt:

    All dates in Freeside are stored as UNIX timestamps.  See the section
    on "time" in the perlfunc manpage.  Also see the Time::Local manpage
    and the Date::Parse manpage for conversion functions.

On Mon, Jul 05, 1999 at 07:43:08PM -0400, Frank Nazario wrote:
> Hi ... i entered a client today that originally paid its 3 month prepaid
> bill  in june ..... i want to know how,with the mysql client that i
> have, i can edit the table cust_pkg.bill  in order to modify the date in
> this table.
> 
> 
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too