seven_days_ago = datetime.combine(
    datetime.today() - timedelta(7),
    datetime.min.time())