On v7, group by date (anywhere), groups results by month and not the day. I understand that there is a workaround to add date to char column and group by that field.
The thing is that i defensively don't want to go through 9-10 modules i have inline and fix them.
is there any other solution?
The problem is your date will be of string type. Please check its type. You have to convert it into datetime and then check. You will get the result