'Group by the specific day, month, and year

I have a table as follow, now I use the group by date and it only group my data based on the year. I want to group the data based on the specific day, month, and year.

Do you know how we can do that?

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source