How to make day by day filtering in mvc?

Question

I have one database that include these fields. ( Id, ItemName, ItemCategory, BuyingDate, Price ).

 

I want to make filtering of BuyingDate to day by day.

For example: There are so many rows with BuyingDate in database. I want to filter how many items are bought on the date(01/01/2001), (02/01/2001), and so on...

 

Kindly give me advice how to implement if you have any idea. Thanks a lot for viewing my question.