Insert duedate

[Anon]

Hi everyone

Could you help me with this.
Im making my own invoicing system on the web, and havent done much with dates before.

I have got the insert of the invoice date wich is now() right. Now i want to add a duedate into the table. How can format this date right (say i want the duedate in 10 days)

Hope you can help with this

Thanks

Tom

[Anon]

Two ways I know of - but you need your invoice date in a Unix timestamp first. You can use strtotime instead of mktime.

// say invoice date is Feb 24 2000

$idate = mktime (0,0,0,2,24,2000);
echo "Invoice ",date ("M-d-Y", $idate),"<br>";

// Method 1: add 11 days, in seconds, to get duedate

$ddate = $idate + (11 * 86400);
echo "Due (1) ",date ("M-d-Y", $ddate),"<br>";

// Method 2: add 11 days and use mktime to get duedate

$idate = mktime (0,0,0,2,24+11,2000);
echo "Due (2) ",date ("M-d-Y", $ddate),"<br>";

Note that mktime happily caters for out of range days when adding or subtracting.

[Anon]

Here's another way, it might be simpler. Do it in your query:

INSERT INTO your_table (start_date,due_date) VALUES (NOW(),NOW() + INTERVAL 10 DAY)

---John Holmes...