Have you tried taking out the groupBy() (both of them) and seeing how the results are returned?
Thanks for the suggestion. Removing the groupBy() still returns the incorrect count.
Your query builder code uses 546 for the datediff() yet you refer to 545 in your comments?
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community