Re: inserting due date into database

php.net says: date ( string format [, int timestamp] ) To turn a php timestamp into something that will be recognized by the mysql DATE type, you might try this: <?php $due_date= //however you set up you invoice+14days timestamp $mysql_date = date("Y-m-d",$due_date);// makes a string like YYYY-MM-DD ?> The php date() function can form just about any string you want to make from a date if you've got a timestamp, which you do. What formate is your original date in? There may be an even simpler way of doing it. -Amos Ruprecht Helms wrote:

Hi, how can I calculate the due date from the date of an invoice and insert the result into a mysql-database. The daydifference is 14 days. Actualy I have tried something with mktimes, but I only get the timestamp of the due date. I have troubles to write that into a dabasefield that was set to datetype. Regards, Ruprecht

-- Amos Glenn amos+amosglenn.com www.amosglenn.com 299 Le Roi Road Pittsburgh, PA 15208 There are 10 kinds of people in the world: those who understand binary and those who don't.