Oh that just makes my brain hurt lol Works though! thanks
On Sep 7, 3:13 pm, Masklinn <maskl...@masklinn.net> wrote: > On 7 Sep 2009, at 15:50 , Rob B (uk) wrote:http://dpaste.com/90621/ > > > (The code in above obviously isn't going to work I'm just using it to > > help illustrate my problem.) > > > I want to show all active promotions between the start date and end > > date. > > So if a promotion starts on 01/01/09 and ends 30/01/09 and a person > > searches from 01/12/08 to 01/02/09 it will still return a result. Also > > if they search from inside the date range e.g. 02/01/09 - 03/01/09 > > they would get the same result. > > > Is there some magical django way of achieving this without looping > > over each day? > > Something along the lines of: > > Promotion.objects.filter(start_date__lt=end_date, > end_date__gt=start_date) > > I'd think. --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---