Hi all.

I currently have a database that stores various details relating to each day in a business. I want to be able to take the last date something was entered and display a form for the user to enter the details for the next seven days.

I have selected the most recent value from the database, which is of type date("Y-m-d"), but now I cannot work out how to increase it.

I have tried to add 1 but that increases it by 1 year, I have tried to increase it by seconds but as it's not a timestamp that doesn't work. I have searched around for a while and had no luck.

So I have considered splitting up the date, increasing the day value and putting it back together, but before I try that does anyone have any suggestions?

Thanks very much,
Dan

$Now=strtotime("2009-02-02"); //Get Unix Time Date 
$Then=strtotime("+1 day",$Now);  //Add a day
date("Y-m-j",$Then); //Output Formatted Date

For More Information See My PHP Date Math Blog

Take a look at the PHP Manual - http://uk2.php.net/manual/en/function.mktime.php

It seems to have exactly what you need.

Originally Posted by rogem002

Take a look at the PHP Manual - http://uk2.php.net/manual/en/function.mktime.php

It seems to have exactly what you need.

mktime is great if your constructing a date from scratch

If your working with an existing date strtotime works better.

Thanks for you help. It now works perfectly!

Dan