laravel-admin
laravel-admin copied to clipboard
Filter between date with complex query
- Laravel Version: 5.6
- PHP Version: 7.3
- Laravel-admin:1.7
Description:
I want to do filter use between to compare date cross table . Is it possible to do it ? example :
$filter->where(function ($query) {
$query->whereBetween('sys_calculation.loan_date',array("YYYY-MM-01",$this->input,));
}, 'loan_date','loan_date')->datetime(['format' => 'YYYY-MM-DD']);
How can i change date time to select date range in this filter ?