Thomas Guettler wrote: > Hi, > > I have a form with two DateFields. If I pass these values > to a range search on a DateTimeField column like this: > .filter(...__range=(form.cleaned_data['start'], form.cleaned_data['end'])) > the end date is excluded. > > > The resulting SQL: > SELECT ... WHERE "mytable"."date" BETWEEN '2008-09-22 00:00:00' and > '2008-09-29 00:00:00' > > I worked around this problem: > end=self.cleaned_data['end'] > end=datetime.datetime(end.year, end.month, end.day, 23, 59) > ...filter(...__range=(form.cleaned_data['start'], end)) > > Maybe this snippet helps someone. > > I guess it would be too much magic to change django, that range > searches with dates values on datetime columns get automatically expanded. > > Thomas > > I'm sorry to day that even your fix still misses out a minute of the range you want. It's an unfortunate side-effect of defining a date as its beginning midnight.
The range generated should really be BETWEEN start-date AND (end-date+1-day). regards Steve -- Steve Holden +1 571 484 6266 +1 800 494 3119 Holden Web LLC http://www.holdenweb.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
