Comparing Dates

[bips2005]

i need to send mail 1 month before expirydate stored in database to a client..till now i can just compare the dates by converting them using strtotime.is there anyways to find out many days are left till expirydate.

[Muddasir]

Hi bips

here it is what I understood you want to do

//considering this date is being fetch from db and was stored in this format
$date = "2008-07-15 22:15:58"; 

$date1 = substr($date, 0, 11); 

$date2 = date("Y-m-d"); // current date

$difference = abs(strtotime($date2) - strtotime($date1));

$days = round(((($difference/60)/60)/24), 0); //remaining days

$date is the expiry date, $date2 is the current date and $days is the total no. of days left till the expiry date.

[hsriat]

How are you doing that, if you can show some code?

[bips2005]

How are you doing that, if you can show some code?

thank you i finally made the code worked

$chexpiraton = strtotime($expiration);
	
	 $today = date("Y-m-d");
	 $chtoday = strtotime($today);
	$diff = $chexpiraton - $chtoday;
	$noday = $diff / (24*60*60);

$expiration contains date from the database;

[hsriat]

thank you i finally made the code worked

$chexpiraton = strtotime($expiration);
	
	 $today = date("Y-m-d");
	 $chtoday = strtotime($today);
	$diff = $chexpiraton - $chtoday;
	$noday = $diff / (24*60*60);

$expiration contains date from the database;

What format is $expiration?.. If its simple UNIX time stamp, then subtract 30*24*60*60 from it and compare it with 'sec' index of gettimeofday array.

[r035198x]

What format is $expiration?.. If its simple UNIX time stamp, then subtract 30*24*60*60 from it and compare it with 'sec' index of gettimeofday array.

See his post above. He's already got it to work correctly.

[hsriat]

See his post above. He's already got it to work correctly.

Oh, thanks for that :)