Thank you for the response,Let me give a try and let you know.
Thanks & Regards sushanth reddy On Tue, May 24, 2011 at 12:30 PM, Ori Livneh <ori.liv...@gmail.com> wrote: > Check out the python-dateutil <http://labix.org/python-dateutil> module > (not in the standard lib, but available via pip and easy_install). It makes > calculating time deltas easy. > > Anyways, try something like this: > > #!/usr/bin/env python > from datetime import datetime > from dateutil.relativedelta import relativedelta > > employees = {} > now = datetime.now() > ranges = [(0, 3), (3, 6), (6, 12), (12, 24)] > > for (a, b) in ranges: > start_date = now - relativedelta(months=b) > end_date = now - relativedelta(months=a) > employees[(a, b)] = Employees.objects.filter( > doj_date__range=(start_date, end_date)) > > On Mon, May 23, 2011 at 3:45 PM, sushanth Reddy <sushant...@gmail.com>wrote: > >> Hi, >> >> How to get model filter on date ranges. In my project using employee doj, >> i need to deign a table. like employee who have joined less than three >> months , 3-6month, 6-12 months, 12-24 months. >> >> Depart < 3month 3-6months 6-12months 12-24months >> >> >> ----------------------------------------- ---- ----- >> >> >> >> A dep 4 6 6 8 >> >> >> >> ------------------------------------------------------ >> >> >> How to do this filter in django. >> >> I have gone through this link ,but its confusing . >> >> http://www.nerdydork.com/django-filter-model-on-date-range.html >> >> Thanks in Advance >> >> -- >> 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. >> > > -- > 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. > -- 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.