Filtering Date By Day's Name

Hello fellows , and here is the new task that was given to me:

In CGridView ,the filter of the column that stores dates needs to be able to find both the correct date of an event (for example: all the events that were on he 24/02/2014) and to be able to filter the dates by the day’s name on which they happen (for example: all the events that were on Monday)

Now , I am using Yii’s datepicker widget and it knows the day of the date , so I guess it is possible somehow. . . .

Simply writing “Monday” in the filter didn’t work , not evn with Full dates format (because in the DB the date is only stored as numbers , I guess)

Any help will be appreciated!

Cheers,

Mark.