NM, just saw Malcolm's post. Michael
On 6/20/07, Michael Trier <[EMAIL PROTECTED]> wrote: > Any chance your field name is causing you problems? Look at the generated > sql. > > Michael > > On 6/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > I had some doubts about my testing because my fields are datetime. > > So I tested it some more and the same problem came up but not only on > > the admin > > > > I have an app with a datetime field. Then I saved enoght objects to > > have one for each day of the month and the same results came up for: > > App.objects.filter(date__gt=datetime.datetime(2007, 5, 21, 0, 0, 0)) > > or > > App.objects.filter(date__gte=datetime.datetime(2007, 5, 21, 0, 0, 0)) > > also the same results for LTE or LT > > > > its it my mistake somewhere? or is it a bug? > > > > Daniel > > > > > > On Jun 20, 6:17 pm, "Daniel Provin" <[EMAIL PROTECTED]> wrote: > > > Hello > > > I notice that the admin has a problem when filtering dates > > > I tried:http://localhost/admin/app/model/?date__lte=2007-06-21 > > > and it generates the same results > > > as:http://localhost/admin/app/model/?date__lt=2007-06-21 > > > so the LTE filter (less than or equal) is giving the same results as the > > > LT > > > (less than only) filter for dates fields (datetime actually) > > > > > > the GTE (greater than or equal) and GT (greater than only) works fine and > > > using the shell from manage.py and filtering using > > > Model.objects.filter(date__lte='2007-06-21) > > > everything works, so I think it is an admin only problem. > > > > > > should I register a ticket? (or is it a ticket only for when I already > > > have > > > the patch?) > > > > > > Daniel > > > > > > -- > > > -- > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
