list_filter on a date field is not working as expected

[onlygoldi2201@…]

I am new user of Django and i am learning it.

I expect books which are getting publish in future date in the current month/year to be shown when i select "this month" or "this year". But it's show results only till current date.

I am attaching some of snapshots of web page and code as well, please let me know if any other information is needed.

[Ramiro Morales]

Thanks for your report.

Which database backend are you using?

[Ramiro Morales]

We've been able to reproduce this with sqlite3 and MySQL

[Baptiste Mispelon]

Some digging up indicates that the regression was introduced in bf0abe0ea6cb492810c5b4f9306a19c8afe603bb.

I reproduced the issue quite simply, using the following model/modeladmin:

class Foo(models.Model):
    publication_date = models.DateField()

class FooAdmin(admin.ModelAdmin):
    list_display = ['pk', 'publication_date']
    list_filter = ['publication_date']

I created four objects with the dates provided in the original report.

[Baptiste Mispelon <bmispelon@…>]

In 8f51ba669aba94eea684ea3f3429fd8e39e70679:

Fixed #21186: Fixed regression when using date fields in the admin's list_filter.

Thanks to onlygoldi2201 for the report and to ramiro and apollo13
for the reviews.

[Baptiste Mispelon <bmispelon@…>]

In c2a35d40db3eca728ac809a3ddb5e8fcec463bca:

[1.6.x] Fixed #21186: Fixed regression when using date fields in the admin's list_filter.

Thanks to onlygoldi2201 for the report and to ramiro and apollo13
for the reviews.

Backport of 8f51ba669aba94eea684ea3f3429fd8e39e70679 from master.

[anonymous]

Replying to ramiro:

Thanks for your report.

Which database backend are you using?

I am using MySql.

[Aymeric Augustin]

Whoops, sorry about that. Thanks everyone for the fix.