kshitizmittal
8 months ago

Month() in multiple join conditions

Posted 8 months ago by kshitizmittal
                                            
$punchData = Employeedetail::join('punchreports',function($join){
                              $join->on("punchreports.emp_id","=","employeedetails.emp_id")
                                    ->on("MONTH('punchreports.date')","=",date('m'));
                          })->get();

Month() not fount error . How can I resolve this?

Please sign in or create an account to participate in this conversation.