Re: Complex queries with datetime field

Hi Malcolm! Well, as you say, the range lookup simplifies the code. I am using MySQL and adding a timedelta of 1 day to a date object and comparing the range with my datetime field works indeed as expected. Thanks for your help. It's been very instructive. ;) Regads, Stefan Malcolm Tredi

Re: Complex queries with datetime field

On Thu, 2009-01-29 at 09:48 +0100, Stefan Tunsch wrote: > Well, first of all I can't believe I've overlooked the __in field > lookup... I wasn't aware of it's existance. Sorry. > > Regarding the __year, __month and __day lookups I'm using in my code: > I do it because I want to filter all dateti

Re: Complex queries with datetime field

Well, first of all I can't believe I've overlooked the __in field lookup... I wasn't aware of it's existance. Sorry. Regarding the __year, __month and __day lookups I'm using in my code: I do it because I want to filter all datetime objects of a specific day. I want to filter all datetime obj

Re: Complex queries with datetime field

On Wed, 2009-01-28 at 16:10 +0100, Stefan Tunsch wrote: > Hi! > > I have a calendar that permits multiple selections of dates. > > My view has to filter the data depending on the selected dates. > > I am unsure about how I can construct a query that filters correctly the > data. > > I constru

Complex queries with datetime field

Hi! I have a calendar that permits multiple selections of dates. My view has to filter the data depending on the selected dates. I am unsure about how I can construct a query that filters correctly the data. I construct my list of datetime objects like this: list = request.session['selected_