I tried something like:
MyModel.objects.filter(year__week=1)
It doesn't work. For now, I calculate the first day and the last day of the week and then use gte and lte, but it's less than efficient given that SQL comes with a Week function.
views:
129answers:
1
+1
A:
It seems that django DateField doesn't have week attribute, as weel as date object from Python. They have both year and month and also day, but not week attribute. I guess you need to translate week to day range and file a ticket on django website ;-)
gruszczy
2010-03-15 10:26:54
That's what I'm doing right now, but it's so boring. Ok for the ticket.
e-satis
2010-03-15 10:38:52
I can tell you what isnt: try writing a patch for django :-) This should be a lot of fun ;-)
gruszczy
2010-03-15 10:42:41
Lol, yeah, as soon as I meet my deadlines I'll do it. Don't wait for me :-D
e-satis
2010-03-15 15:42:24
You seem to have a lot of time to spend on SO, so maybe you find a little to code something for django ;-)
gruszczy
2010-03-15 15:58:58
make sure you mark this answer as accepted.
Goose Bumper
2010-03-16 17:06:16