Please is there anything i'm doing wrongly, filtered base on datetime, empty QuerySet

i got an empty QuerySet<[]>, i'd like to confirm if my models filtered are working before proceeding but seems the queryset from SubscribeEmailModel filtered from topic__startdate coming out as empty query

here is my models.py 

 class Lesson(models.Model):
    name = models.CharField(max_length=234)
    startdate = models.DateField(auto_now=True)

 class SubscribeEmailModel(models.Model):
       topic = models.ForeignKey(Lesson)

please here is my views.py

  class AutoSendNotification(ListView):
    subscriber =SubscribeEmailModel.objects.filter(topic__startdate=datetime.datetime.today(), 
          sent_mail=False)
         print(subscriber)

      model = SubscribeEmailModel
      context_object_name = 'subscriber'
      template_name = 'superadmin/email/auto-send.html'

You are trying to filter the exact datetime with the current datetime which might not match.

If you are trying to filter out based on date then set topic__startdate__date in filter

today = datetime.datetime.today().date()
subscriber = SubscribeEmailModel.objects.filter(topic__startdate__date=today, sent_mail=False)

If you are trying to filter out based on date less than or greater than then set topic__startdate__gt or topic__startdate__lt in filter

today = datetime.datetime.today()
subscriber = SubscribeEmailModel.objects.filter(topic__startdate__lt=today, sent_mail=False)

you're fetching date including Timestamp which can cause issue.

just make sure you have data created on current date. try this

from datetime import date

today = date.today()
subscriber =SubscribeEmailModel.objects.filter(topic__startdate=today, 
          sent_mail=False)
Back to Top