Django count today's logged in users

Question

I want to show on my admin interface the count of the users those did log in today. My admin interface looks like following:

When I print from my view

 count = User.objects.filter(last_login=timezone.now()).count()

it gives me 0 as both the date/time format are different. i.e. 2016-06-01 14:58:29.079000+00:00

How can I get that count on my admin interface somewhere?

score 2 · Accepted Answer · edited May 23 '17 at 12:31

2

You have to get the date from the timezone.now() and then use filter 'startswith' to filter by date:

count = User.objects.filter(last_login__startswith=timezone.now().date()).count()

In addition to add this column to your Django Admin Interface you can check this Custom columns using Django admin

edited May 23 '17 at 12:31

Community

answered Jun 01 '16 at 15:10

ezdookie

Yes the first answer solves my problem. Second answer is also correct, however what I want is bit different, not just adding a column but customizing widget. take a look here, if you would like to answer separately: http://stackoverflow.com/questions/37579348/django-show-object-count-on-admin-interface – Thinker Jun 02 '16 at 08:57

score 0 · Answer 2 · edited May 24 '20 at 06:33

0

I think this should work:

count = User.objects.filter(last_login__startswith=timezone.now().date()).count()

edited May 24 '20 at 06:33

Nimantha

answered May 24 '20 at 05:41

Sameer Verma

2 Answers2