laravel-admin icon indicating copy to clipboard operation
laravel-admin copied to clipboard

Filter between date with complex query

Open sunsophearoth opened this issue 1 year ago • 0 comments

  • 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 ?

Steps To Reproduce:

sunsophearoth avatar Aug 25 '22 08:08 sunsophearoth