Re: Filter by retirement age?

Thanks Nikolas - that works.

cheers

L.

On Wednesday, May 9, 2012, Nikolas Stevenson-Molnar wrote:

On your second attempt, the problem is that you are trying to call the datetime module, not the datetime class. Change it to datetime.datetime(...) and you should be fine there.

_Nik

On 5/8/2012 4:12 PM, Lachlan Musicman wrote:

Hola,

I have a model Person with a dob = models.DateField()

I would like to filter by age - in particular only include people less than 60 years old.

I am having no luck getting the syntax right and was looking for pointers?

          queryset=Person.objects.filter(dob__year__gte = datetime.datetime.today().year-61)

gets me an error like: Join on field 'dob' not permitted. Did you misspell 'year' for the lookup type?

 

RETIRE_Y = datetime.datetime.today().year-61

...

              queryset=Person.objects.filter(dob__gte = datetime(RETIRE_Y,1,1)))),

gives me errors like: 'module' object is not callable

I don't want to create a new field or function on the Person object that would calculate "age" everyday...

What am I doing wrong/how can I make it right?

cheers

L.

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.