how to dispaly back date ??

Anon

I have got a date format which is stored in mysql databse .. the format is

$date_admin=date("d/m/Y");

means $date is 28/02/2002

What if I want to check a day back format??

mean .. i have to search from mysql where date is a day back from current date but only in the above format..

how can i get $date="a day back from current date but in "28/02/2002" format ??

Any Idea ??

Anon

You should really do a search on the site before posting a question.. check this column published on here:
http://www.phpbuilder.com/columns/akent20000610.php3

(page 4 in particular has stuff u would be interested in)

Anon

Hi,

You should be using DATE or DATETIME mysql fields to be able to select records before/after a certain date and for a number of other cool functionality. If you store them as strings, you'd better change your table's design because it will be very hard to manipulate text in order to determine which date is earlier than the given date, for instance. The only way this would work with text is when you have date in the format
'YYYY/MM/DD' stored in the database, because in this case you can simple compare the given formatted date to the ones in the database to retrieve all records earlier or older than the formatted date.
But again, this is bad practice when you have MySQL's date/datetime field types because they give you more options, such as retrieving the month using MONTH() function, or adding a number of days/months/years to a ddate in the database.

MySQL has DATE_FORMAT function to format dates as you need.

All Date functions are well documented in MySQL's manual.

Hope this helps,
Stas

Anon

<h1>message</H1>

Anon

I built a function a while back to handle this problem, it may be a little clunky, but it works.

The date I was formatting looked like this: 2000-12-31. I've modified the function so it should meet your needs, you can have it reaarange the format by changing the last line in the function.

The reason it is so clunky is because I found that PHP drops the '0' off the front of the date when you try to back it up. For this reason, I had to do a loop to check to see if the date was supposed to have a '0' in front of it. The zero was very important to me in matching up dates within my database.

function previousDate(&$inputdate) {
$date = explode("/", $inputdate);

$month = $date[1];
$year = $date[2];
$day = $date[0];

if (($month == "1") && ($day == "1")) {
	$month = "12";
	$year = --$year;
	$day = "31";
} else if(($month == "1") && ($day != "1"))  {
	$day = $day - "01";
} else if (($month != "1") && ($day == "1")) {
	$month = --$month;
	$day = "31";
} else {
	$day = --$day;
}

if ($day <= "9")  {
	$addzero = "0";
	$addzero .= $day;
	$day = $addzero;
} else {
}

if (($month <= "9") && ($day == "31"))  {
	$addzero = "0";
	$addzero .= $month;
	$month = $addzero;
} else {
}

$inputdate = "$day/$month/$year";

}

You probably know, but just in case, call the function by:

$date = "22/02/2002";
$date = previousDate($date);

Date returned will be:

21/02/2002

Anon

thanx joe but it's strange because it is not displaying anything ??? i am stuck ..

i use echo($date) and the result is blank ..

what happend ??

Anon

it's working actually you forgot to put return in your function ..

but hey.. what if the month is februery ?? your function will retun 31 Feb. if the date is 1 march .. and there are so many pitfalls ..

what if the month is of 30th then it would also return 31 and what about the leap year ??

Any Idea ??

Anon

Hi!

If you need to know the previous date, just get the previous timestamp with maketime

mktime (int hour, int minute, int second, int month, int day, int year [, int is_dst])

pass to it the return values of date() function for appropriate date components, but instead of date("d"), pass to it date("d") - 1.

Then pass this timestamp as the second argument to date(), specifying the required format in the first argument.

That's it. No need to reinvent something PHP handles wonderfully. Unless I didn't get the message right :-)

Best regards,
Stas

Anon

Hi Stanislav Okhvat,

That was really cool one .. it makes sense..I have done it ..
Thanx a lot buddy !!

Regards
Tabish

Anon

Hi again!

Always glad to help

Stas

Anon

Tabish,

Your right, I didn't build that functionality in because I was matching the date up with my database. So it didn't matter if the date was Feb. 31st because it simply wouldn't find that date in the database and would backup another day.

Is that as clear as mud? Trust me. My fault for not remembering that.

Looks like Stanislav had a better solution anyways. Wish I would have known about that. Then I wouldn't have had to re-invent the wheel. Oh well.

Sorry for the confusion.

Anon

it's ok Joe.. being helpfull is as lovable as something couldn't be. I appricitae your kind consideration... Thanx a lot.. to you too..