status.effectivedate is when a status 'starts', (like closed for repairs.) How do I get the 'current status based on current date' ?
so if the following 3 records are in the table: status effective date, description 1/1/2007 - open for business 3/24/2007 - closed for remodeling 5/1/2007 - open with a new look. 11/14/2007 - closed for Christmas 1/1/2008 - open - happy new year. So right now, the status is "open with a new look." when it is 11/14, the current status will be "closed for Christmas." The SQL is a big ugly, hoping the ORM will make it for me. If not, I'll add it. can someone point me to where I should look? Carl K --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
