Re: [PHP-WIN] Date Problem

2012-06-21 Thread John Harris
On 21 Jun 2012 8:43, Huiberts, Pieter J. wrote > Sorry gentlemen, quick question how do I unsubscribe from this list? > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php Follow the information provided? -John -- PHP Windows Mailing List

RE: [PHP-WIN] Date Problem

2012-06-21 Thread Huiberts, Pieter J.
Sorry gentlemen, quick question how do I unsubscribe from this list? Pieter J.D. Huiberts M.S. | SAIC Sr. Software/Database Engineer | Life Sciences Operation | Health Solutions Business Unit phone: 240-529-0411 | mobile: 240-357-5885 pieter.j.huibe...@saic.com | www.saic.com -Original Messa

Re: [PHP-WIN] Date Problem

2012-06-21 Thread Jacob Kruger
I wouldn't really be the perfect person to answer this question, but does sound about right to me...:) Stay well Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...' - Original Message - From: Vinay Kannan To: Toby Hart Dyke ; ja...@blindz

Re: [PHP-WIN] Date Problem

2012-06-21 Thread Vinay Kannan
Hi Toby, Jacob Thank You Toby and Jacob for your help! I figured my way out and was able to fix the issue, what i did was, i built another table called servicesdue and updated the columns service1,service2,service3, used DATE_ADD to populate these 3 date fields. I figured the best way to go forwa

Re: [PHP-WIN] Date Problem

2012-06-21 Thread Jacob Kruger
While this might not be perfect/exact information, here's a link to the w3schools.com date/time functions reference page, and, off-hand, you could convert a date string into a timestamp, and then just add, or subtract the relevant timestamp amount from it, using the sort of formula that a times

RE: [PHP-WIN] Date Problem

2012-06-21 Thread Toby Hart Dyke
The date_add() function is your friend here. You will need to define what happens when the start date is something like Nov 30th. When is the first service due after that? If you use date_add() to add three months, it will return March 1st (in a non-leap year). Your first step should be to define