I have two tables Member table and Daily_Notes table.
class Member(models.Model):
name = models.Charfield()
Daily_notes table
class DailyNotes(models.Model):
member= models.Foreignkey('Member')
note=models.Charfield()
date=models.Datetimefield(default="")
Daily note table contains daily entries
I need to filter datas, If user have not enter note by today and entered the prior day.
You can retrieve Members that have filled in a DailyNotes item the previous day and not the current day with:
from datetime import date, timedelta
Member.objects.filter(
dailynotes__date__date=date.today() - timedelta(days=1)
).exclude(
dailynotes__date__date=date.today()
)