Can we apply date range filter on date if date data type or dtype is text or str?

models-
`class RocCharge(models.Model):`
`charge_id = models.IntegerField(blank=True, null=True)`
`chname = models.CharField(max_length=100, blank=True, null=True, db_index=True)`
`date_of_creation = models.TextField(default=date.today)`

views-
`from_date = request.GET.get('fromdate')`
`to_date = request.GET.get('Todate')`
`if from_date and to_date:
    combined_data = combined_data.filter(date_of_creation__gte=from_date, date_of_creation__lte=to_date)`

my date of creation in mysql as well as in models in text format , but i want to perform date range filter from to range without changing date data type , my date in mysql like-21-12-2019

# ...

from_date_str = request.GET.get('fromdate')
to_date_str = request.GET.get('Todate')

if from_date_str and to_date_str:
    # Convert date strings to datetime objects using a consistent format
    date_format = "%d-%m-%Y"
    from_date = datetime.strptime(from_date_str, date_format)
    to_date = datetime.strptime(to_date_str, date_format)

    # Filter based on the datetime range
    combined_data = combined_data.filter(date_of_creation__range=(from_date, to_date))

This involves converting the date strings from the request parameters to datetime objects using strptime and then using the __range lookup to filter based on the date range. This should work with your current text-based date.Make sure date format is correct.

Back to Top