Filter all entries created today

Question

I am attempting to filter all entries in a table created today, but it wont allow me to use .date() on the column created.

Here is the sourcecode for the filter:

StartupHistory.objects.filter(user=2).filter(created.date()=datetime.date.today())

Example

>>> resultset = StartupHistory.objects.filter(user=2)
>>> for element in resultset:
...     print element.created.date()
... 
2014-03-12
2014-03-12
2014-03-12
2014-03-12

possible duplicate of [Django filter events occurring today](http://stackoverflow.com/questions/11245483/django-filter-events-occurring-today) — alecxe, Mar 12 '14 at 14:16
@alecxe, that is described in a slightly different context compared to mine. — JavaCake, Mar 12 '14 at 14:22
How about `StartupHistory.objects.filter(user=2).filter(created__date=datetime.date.today())` — karthikr, Mar 12 '14 at 14:24
@karthikr, been down that road i get following error `Join on field 'created' not permitted. Did you misspell 'date' for the lookup type?` — JavaCake, Mar 12 '14 at 14:25
Ok. How about just `StartupHistory.objects.filter(user=2).filter(created=datetime.date.today()‌)` ? — karthikr, Mar 12 '14 at 14:27
created=datetime.date.today()‌ won't work if created is a datetime field — Łukasz Staniszewski, Mar 12 '14 at 14:37

score 2 · Accepted Answer · answered Mar 12 '14 at 14:29

2

You can filter it like this:

StartupHistory.objects.filter(user=2).filter(created__startswith=datetime.date.today())

answered Mar 12 '14 at 14:29

Łukasz Staniszewski

668
6
15

i tried a few different things and this was the most accurate thanks – Dap Jun 27 '14 at 17:37

Filter all entries created today

1 Answers1