int() argument must be a string or a number, not 'datetime.date'

According to me in the qs line I am looking at, for example, results from Booking where 2014-07-17 equals 2014-07-17 as in date field comparison I dont even see where an int() argument comes into it

dl_reports.py

class SelectDate(forms.Form):
    def __init__(self, *args, **kwargs):
        super(SelectDate, self).__init__(*args, **kwargs)
    arrival_date = forms.DateField(required=False, input_formats=('%d/%m/%Y',), help_text='Enter a date in the format DD/MM/YYYY')
    departure_date = forms.DateField(required=False, input_formats=('%d/%m/%Y',), help_text='Enter a date in the format DD/MM/YYYY')


@staff_member_required
@never_cache
def travel_by_date_report(request, fields=None):
    form = SelectDate()
    arrival_date = ''
    departure_date = ''
    if request.GET:
        form = SelectDate(request.GET)
        if form.is_valid():
            if form.cleaned_data.has_key('arrival_date') and form.cleaned_data['arrival_date'] != '':
                qs = Booking.objects.filter(arrival_date=form.cleaned_data['arrival_date'])    //this is line 33
..etc


Booking model:

class Dates(models.Model):
    day = models.CharField(choices=DAY_CHOICES, max_length=12)
    travel_date = models.DateField()

class Booking(models.Model):
    name = models.CharField(max_length=150)
    email = models.EmailField()
    telephone_mobile = models.CharField(max_length=30, blank=True, null=True)
    arrival = models.ForeignKey(ArrivalLocations, null=True, blank=True)
    arrival_date = models.ForeignKey(Dates, related_name="Date of Arrival", blank=True, null=True)


Traceback:
Traceback:
File "/home/paston2/webapps/latitude/lib/python2.7/django/core/handlers/base.py" in get_response
  111.                         response = callback(request, *callback_args, **callback_kwargs)
File "/home/paston2/webapps/latitude/lib/python2.7/django/contrib/admin/views/decorators.py" in _checklogin
  19.             return view_func(request, *args, **kwargs)
File "/home/paston2/webapps/latitude/lib/python2.7/django/views/decorators/cache.py" in _wrapped_view_func
  79.         response = view_func(request, *args, **kwargs)
File "/home/paston2/webapps/latitude/latitude/dl_reports.py" in travel_by_date_report
  33.                 qs = Booking.objects.filter(arrival_date__gte=form.cleaned_data['arrival_date']).filter(arrival_date__lte=form.cleaned_data['arrival_date'])
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/manager.py" in filter
  141.         return self.get_query_set().filter(*args, **kwargs)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/query.py" in filter
  550.         return self._filter_or_exclude(False, *args, **kwargs)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/query.py" in _filter_or_exclude
  568.             clone.query.add_q(Q(*args, **kwargs))
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/sql/query.py" in add_q
  1194.                             can_reuse=used_aliases, force_having=force_having)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/sql/query.py" in add_filter
  1129.                 connector)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/sql/where.py" in add
  67.             value = obj.prepare(lookup_type, value)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/sql/where.py" in prepare
  316.             return self.field.get_prep_lookup(lookup_type, value)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/fields/related.py" in get_prep_lookup
  136.             return self._pk_trace(value, 'get_prep_lookup', lookup_type)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/fields/related.py" in _pk_trace
  209.         v = getattr(field, prep_func)(lookup_type, v, **kwargs)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/fields/__init__.py" in get_prep_lookup
  292.             return self.get_prep_value(value)
File "/home/paston2/webapps/latitude/lib/python2.7/django/db/models/fields/__init__.py" in get_prep_value
  479.         return int(value)

Exception Type: TypeError at /dailyreport/
Exception Value: int() argument must be a string or a number, not 'datetime.date'

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c0b86df1-5034-4df8-b7a2-9a680bedfd80%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.