Sorting by month on date fields in GridView

Yii 2.0 General Discussions
1

I have a couple of date fields with format something like ‘2015-24-05’.

Within the GridView out of box filter at the top of the widget, is there a way that I can enter month ‘05’ or ‘2015-05’ for example, such that it filters on that month ?

Neither of those search terms work, not sure if its at all possible ?

2

u can try this. it works in my case,


 $time= $this->created_at ; 

        $query->andFilterWhere([ 

            'MONTH(created_at)' => $time, 

        ]);

mark "+" if solved.

3

where does that go in relation to the GridView widget ?

4

as i understand filtering in grid view is depends on this only.

regards,

rups g

5

Any ideas on how to do this ?

Using GridView widget, I want to be able to filter using the built in feature, to display the rows using a date field for a particular month, ie, 2015-06, or 06