Hi guyz,

I need to know how to create a filter in which the invoices for this month(06/June) to be displayed.

For example :

I have 3 records with  datetime field :
rec1                        -           12/06/2013  13:54:39                            
rec2                        -           20/06/2013  12:12:58
rec3                        -           05/05/2013  05:30:25

So when the filter is created using todays date: 'date1': fields.date.context_today,

I need to show only rec1 and rec2 as the current month is 06.

If we need the invoice for todays date, we can use this query :

[['date_invoice','=',time.strftime('%Y-%m-%d')]]