Filtering records by existing month
I have database of records showing working time. So for each day there will be one or more records for multiple users. There will be a lot of records at the end of the month so I want to make list simpler and show just current months records.
IDEA ON SOLUTION: I want to have drop down list with months so user can select which month to show. In this list there should be just months in which there is some record created.
So if there is just records for november 2013 and december 2013 there would be just those two months to select in drop-down list.
What is the best way to achieve this?