Date Calculations

[brodellis]

I'm trying to implement a logichook for Tasks module. I'm simply trying to get the difference between the start_date and end_date of the tasks. I'm new to PHP and SugarCRM so if there is an internal function that I can use please let me know. Any guidance provided is greatly appreciated.

The section of code in question is highlighted in red below.

Thanks,
Brod

Version: 5.1.0b
Windows
MySQL 5.0.51b


<?php
function lookup_year_week(&$year_num, &$week_num, $start_date){
//try if this can obtain db connection, might not work
global $timedate;
$db_date = $timedate->swap_formats($start_date, $timedate->get_date_format(), $timedate->dbDayFormat);

$db = DBManagerFactory::getInstance();
$query = 'select year, week from week_period where start_date <=\''. $db_date . '\' AND end_date >=\''. $db_date . '\'';
$result = $db->query($query, true, $app_strings['ERR_EXPORT_TYPE'].$type.": <BR>.".$query);
$row = $db->fetchByAssoc($result, -1, false);
$year_num = $row['year'];
$week_num = $row['week'];

}


function date_diff($end_date, $start_date){
error_log($end_date . " " . $start_date . "\r\n", 3, "bellis.log");

$timedate = new




$dateDiff = $end_date - $start_date;

error_log($dateDiff . "\r\n", 3, "test.log");
$fullDays = floor($dateDiff/(60*60*24));
$fullHours = floor(($dateDiff-($fullDays*60*60*24))/(60*60));
$fullMinutes = floor(($dateDiff-($fullDays*60*60*24)-($fullHours*60*60))/60);

error_log($fullMinute, 3, "bellis.log");
return $fullMinutes;
}

[andopes]

Hi brodellis

You can use the datediff built in MySQL date function.
To deal with the calculated date you need to fill some $focus attribute with this calculated value.

[brodellis]

I've figured out how to retrieve the two date values in the following formats:

Field 1: 1/22/2009 10:30:00 PM

Field 2: 1/22/2009 11:00:00 PM

The question I have now is how do I calculate the difference between the two times.

Forgive me if this is a basic question, but I"m new to PHP and SugarCRM and need a bit of guidance.

Thanks

[mvngti]

Field 1: 1/22/2009 10:30:00 PM
Field 2: 1/22/2009 11:00:00 PM
The question I have now is how do I calculate the difference between the two times.

 $diff_in_seconds = strtotime($field1) - strtotime($field2);
$diff_in_hours = floor((strtotime($field1) - strtotime($field2))/3600);
$diff_in_days = floor((strtotime($field1) - strtotime($field2))/86400);