date difference

[fariba123]

hi

i have developed an employee details web site. there is an option to view employee's experience.

in professional experience part i have:
start date: 01 Mar 2006 and end date:05 Oct 2006

how can i get the difference between the above dates in the following format:
days worked:x year (s), y month (s), z day (s)

please give a quick reply.

thank you

[ronverdonk]

Since no one answered this (yet):

I myself use a PHP class named "Simple Date Time Object" that does all my date/time calculations, also the one you are asking for. You'll find this class at STDO class

The function you look for is the "diff_MySQL function" (don't be mislead about the word MySQL, it handles you dates fine in the format YYYYMMDDHHMMSS).

Sorry I couldn't show you any code for this.

Ronald :cool:

[ctsasikumar]

Hai Use this code it's working perfeclty........i done this same type of application

$database_date=$acess[3];
$database_date."<br>";
$check_date=explode("-",$database_date);
$current_year=date("Y");
$current_month=date("m");
$current_day=date("d");
$end_year=$check_date[0];
$end_month=$check_date[1];
$end_day=$check_date[2];
$current_date=gregoriantojd($current_month,$curren t_day,$current_year);
$final_date=gregoriantojd($end_month,$end_day,$end _year);
$possible_acess_date=$final_date-$current_date;

Sasi

[fariba123]

thanks for the reply. but i failed to understand the usability for date in which format (i.e. [26 Feb 2006] or [Feb26 2006] or [26/02/2006] ).

it will be great if you explain with a date example.

thanks

Hai Use this code it's working perfeclty........i done this same type of application

$database_date=$acess[3];
$database_date."<br>";
$check_date=explode("-",$database_date);
$current_year=date("Y");
$current_month=date("m");
$current_day=date("d");
$end_year=$check_date[0];
$end_month=$check_date[1];
$end_day=$check_date[2];
$current_date=gregoriantojd($current_month,$curren t_day,$current_year);
$final_date=gregoriantojd($end_month,$end_day,$end _year);
$possible_acess_date=$final_date-$current_date;

Sasi

[ctsasikumar]

Hai ...

GregorianToJD this is php function...

this function syatax is
gregoriantojd(month,day,year);

....

so i get in the curret date value is first value

$current_year=date("Y");
$current_month=date("m");
$current_day=date("d");

$current_date=gregoriantojd($current_month,$curren t_day,$current_year);

the second i get database value.....

split the database value in our form using explode function

$database_date."<br>";
$check_date=explode("-",$database_date);
$end_year=$check_date[0];
$end_month=$check_date[1];
$end_day=$check_date[2];

after just subtraction of two value

$possible_acess_date=$final_date-$current_date;

this is given some numeric number....

u want year wise means

$year=$possible_acess_date/365;

do u want month wise means
$month=$possible_acess_date/30;

that'a ll

[ronverdonk]

I fail to see how a Gregorian to Julian date function can help with the problem in this thread.

(ctsasikumar: before you dump any code in this forum, read the Posting Guidelines at the top of this forum!! And extra attention for the part about enclosing shown code within php, code or html tags!)

Ronald :cool: