I have three tables in database
tableA
tableB
tableC
All these three table have document_date.
$date1 = '2023-01-01';
$date2 = '2023-08-01';
I need eloquent with model for
max(
( max of document_date in table A wherebetween $date1 and $date2),
( max of document_date in table B wherebetween $date1 and $date2),
( max of document_date in table C wherebetween $date1 and $date2)
)
The result should be one date.
$date1 = '2023-01-01';
$date2 = '2023-08-01';
$maxDate = max(
TableA::whereBetween('document_date', [$date1, $date2])->max('document_date'),
TableB::whereBetween('document_date', [$date1, $date2])->max('document_date'),
TableC::whereBetween('document_date', [$date1, $date2])->max('document_date')
);