Date Problems again.....

wilburburns

I would have never thought that formatting a simple expiration date would kick my butt so much but it has...

OK, the end goal is to calculate a date XX amount of months in advance for an item to expire. I think I should be able to do this with mktime(). However, currently, I'm seeing discrepencies which I cannot explain, so please Help.

<?php 
echo "echoing the test Date 1977-02-26<br />";
$birthtime = strtotime('1977-02-26');
$day = date("d", $birthtime);
$month = date("m", $birthtime);
$year = date("Y", $birthtime);
$birth1 = date("F d Y", strtotime('1977-02-26'));
echo $birth1;
echo "<br>";
echo date("F d Y",$birthtime);
echo "<br>";
$why = date("mdY", mktime(0,0,0,$day,$month,$year));
echo $why;
echo "<br>day=".$day."<br>month=".$month."<br>year=".$year;

The above code returns Some form of February 26 1977 for every value EXCEPT $why .
$why returns 02021979

Can someone please explain to my what is really going on. I have been scouring the manual pages and old posts without any luck.

Thanks,
Cliff

[Mod Edit] Please don't try to get around the filters.

aduljr

is this going into a SQL database by chance? Its much easier to do within MySQL.

wilburburns

aduljr wrote:
is this going into a SQL database by chance? Its much easier to do within MySQL.

YES........BUT.......
Unfortunately, I am working within the confines of an API which does not allow me to perform my own queries. All I can really use are the results of their query, which has the date as shown..

1977-02-26

Sucks, but that is what I have to work with... ARRGGHHHH

Cliff

aduljr

try str_to_time()
http://www.php.net/manual/en/function.strtotime.php

I found it easier to deal with.

wilburburns

aduljr wrote:
try str_to_time()
http://www.php.net/manual/en/function.strtotime.php

I found it easier to deal with.

Thank You,
strtotime() is working like a charm to calculate dates in the future...

As shown above, I was already using strtotime() to create a useable format for date() , but I didn't even consider using the same function to add months or weeks to the original date..

I still don't understand why my original test script from above is returning different values though. In pieces everything returns the values as expected, but the mktime() is adding 3 years... If anyone can explain this to me that would be great..

Cliff

aduljr

wilburburns wrote:
Thank You,
strtotime() is working like a charm to calculate dates in the future...

As shown above, I was already using strtotime() to create a useable format for date() , but I didn't even consider using the same function to add months or weeks to the original date..

I still don't understand why my original test script from above is returning different values though. In pieces everything returns the values as expected, but the mktime() is adding 3 years... If anyone can explain this to me that would be great..

Cliff

$why = date("mdY", mktime(0,0,0,$month,$day,$year));

wrong order of the month day year in your code.