Re: Model filter on date ranges

[sushanth Reddy]

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  wrote:

> Check out the 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 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   46 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.

Re: Model filter on date ranges

[Ori Livneh]

Check out the 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 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   46 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.