cannot resolve FieldError

[frank dilorenzo]

I am getting this error message:

raise FieldError("Cannot resolve keyword '%s' into field. "

django.core.exceptions.FieldError: Cannot resolve keyword 'date' into field. Choices are: bad, created, doa, entered, id, non, para, received, released, slabel, specie, specie_id, supplier, supplier_id

these are my models:

Shipment:

class Shipment(models.Model):

supplier = models.ForeignKey(Supplier, on_delete=models.CASCADE)

created = models.DateTimeField(default=timezone.now)

slabel = models.CharField(max_length=10)

specie = models.ForeignKey(Specie, on_delete=models.CASCADE)

received = models.PositiveIntegerField(default=0)

bad = models.PositiveIntegerField(default=0)

non = models.PositiveIntegerField(default=0)

doa = models.PositiveIntegerField(default=0)

para = models.PositiveIntegerField(default=0)

released = models.PositiveIntegerField(default=0)

entered = models.BooleanField(default=False)

def get_absolute_url(self):

return reverse("shipments:detail", kwargs={"pk": self.pk})

def __str__(self):

return f"{self.specie.name}-{self.created.strftime('%Y/%m/%d')}-{self.supplier.name}"

suppliers:

class Supplier(models.Model):

supplierID = models.PositiveIntegerField(default=1)

name = models.CharField(max_length=120)

logo = models.ImageField(upload_to="suppliers", default="no_picture.png")

phone = models.CharField(max_length=15, null=True)

email = models.CharField(max_length=120)

country = models.CharField(max_length=120, null=True, blank=True)

address = models.CharField(max_length=120, null=True, blank=True)

city = models.CharField(max_length=120, null=True, blank=True)

state = models.CharField(max_length=120, null=True, blank=True)

zipCode = models.CharField(max_length=10, null=True, blank=True)

def __str__(self):

return self.name

species:

class Specie(models.Model):

name = models.CharField(max_length=50)

image = models.ImageField(upload_to="species", default="no_picture.png")

created = models.DateTimeField(default=timezone.now)

def __str__(self):

return self.name

class Meta:

ordering = [

"name",

]

everything is working the way I want but when I try to get data into a variable I get the above error and I don't have a clue where to start to resolve this.  As from the models I have no field named date so I am confused.

The error is generated by this line:

qs = Shipment.objects.filter(date__range=[date_from, date_to])

even if I enter strings for testing, for example

qs = Shipment.objects.filter(date__range=['2021-01-01', '2021-02-01'])

I been all over the web looking for possible solutions but I am at a loss.  Thanks for any thoughts or suggestions you may have.

[Arshad Noman]

django.core.exceptions.FieldError: Cannot resolve keyword 'y' into field. Choices are: author, category, id, isbn, name

I am also getting the same error.