How to Create function that Calculate nbr of days difference ?

[Jaidee]

DaDaBIK version 11.9-Elba enterprise, installed on 06-28-2023
PHP Version: 7.4.33
mysql version: 8.0.31
Web server: Apache/2.4.54 (Win64) PHP/7.4.33

I expect the nbr of days differnce to return
My solition dont work ??? How do I do ?
base_fee, end_date, start_date defined.

function dadabik_duration($params)
{ if ( $params['base_fee'] !== 0 )
{
return (dateDiff ($params['date_end'], $params['date_start']);
}

}

 

[deep64blue]

You are using SQL syntax in a php script try replacing dateDiff with date_diff.

 

[Jaidee]

Sorry but the above was not of any help.

However, was finally able to find the solution via ai.gpt as follows;

Difference of days between begin & End date

function dadabik_time6($params) {
if ($params['base_fee'] !== 0) {
$datstt = $params['start_date'];
$datend = $params['end_date'];

// Calculate the time difference in seconds
$timeDifferenceInSeconds = strtotime($datend) - strtotime($datstt);
// Convert seconds to days
$daysDifference = floor($timeDifferenceInSeconds / (60 * 60 * 24));
return $daysDifference;
}
// Return 0 if base_fee is 0
return 0;
}