Time Calculation

[symcom]

I want to calculate the time in a calc element between A and B using:

A = {pgs8r_liondata___fire_detection} (date element)
B = {pgs8r_liondata___fire_reportignition} (date element)

From what I could find on the forums I tried:

$date = strtotime ('{pgs8r_liondata___fire_detection}');
$date1 = strtotime ('{pgs8r_liondata___fire_ignition}');
$diff = $date - $date1;
return $diff;

Will appreciate some guidance to achieve this.

 

[rob]

seems right to me, what results are you seeing?
Have you checked the data that is contained in {pgs8r_liondata___fire_detection} ?
Have you tried {pgs8r_liondata___fire_detection_raw} instead?

 

[symcom]

Thanks Rob, tried _raw but same result
Below is the results and data -
pgs8r_liondata___fire_detection | data = "2012-04-22 19:30"
pgs8r_liondata___fire_ignition | data = "2012-04-22 17:45"
result data = "-1335109500"

 

[mk13]

To read pretty hard for me but If you were hurried , see:
http://fabrikar.com/wiki/index.php/Deciding_in_PHP_if_a_date_within_an_age_range
http://fabrikar.com/wiki/index.php/Difference_in_days_between_2_dates_in_PHP

 

[rob]

$d = strtotime('2012-04-22 19:30');
$d2 = strtotime('2012-04-22 17:45');
$diff = $d - $d2;
echo $diff;

gives me :

6300

are you doubly sure that you are actually getting the values in the place holders?

 

[cheesegrits]

Try changing your return value to ...

return $diff . " ({pgs8r_liondata___fire_detection}, {pgs8r_liondata___fire_reportignition})";

... and see what that yields, just to check what those placeholders are set to. If you get something like [array] instead of a value, try adding _raw to the names, and see what you get.

-- hugh

 

[symcom]

Thank you Rob & Hugh problem has been solved.

Did an un-install, removed tables and then a new install with latest SVN.

Now the work can start.