[RESOLVED] Date differences/comparison

new_programmer

Hi guys

I have two dates.. Wednesday 12th of July 2006 03:53:57 PM and Monday 31st of July 2006 03:49:49 PM

I need to find out the days between these two dates. Now how exactly would i do that?. I tried using strtotiime.. but it gives me -1 for some reason.

Please help

Thanks in advance

NogDog

What is the source of these dates? I'm mainly asking because if they come from a database datetime field, then you may be able to use the database's date arithmetic functions to do the calculation, or else at least output them in a more useable format.

new_programmer

NogDog wrote:
What is the source of these dates? I'm mainly asking because if they come from a database datetime field, then you may be able to use the database's date arithmetic functions to do the calculation, or else at least output them in a more useable format.

Thanks for the quick reply

yes they do come from mysql db. but the field is not Datetime.. its a varchar field.

another odd thing is .. when i try to grab lets say month.. from date("m","Wednesday 12th of July 2006 03:53:57 PM")
it gives me some wierd date.. in 1969

not sure wat im doing wrong

Thanks,

new_programmer

Hello guys..I solved it.. might not be the simpler way but it does wat i want.

$first_date = "Wednesday 12th of July 2006 03:53:57 PM";
$second_date = "Monday 31st of July 2006 03:49:49 PM";

//convert into arrays 
$firstdate = split(" ",$first_date);
$seconddate = split(" ",$second_date);

//arrays 1,3,4 elements contain day, month, year			

$myfirstdate = getMonthNum($first_date[3]) . "-" . substr($first_date[1],0,2) . "-" . $cdate[4];
$myseconddate = getMonthNum($second_date[3]) . "-" . substr($second_date[1],0,2) . "-" . $seconddate[4];

//heres a small function that returns month number
function getMonthNum($month_str){
$month_num = array("January"=>"01","February"=>"02","March"=>"03","April"=>"04","May"=>"05","June"=>"06","July"=>"07","August"=>"08","September"=>"09","October"=>"10","November"=>"11","December"=>"12");
return $month_num[$month_str];



}

hope it helps others