Can I store full dates (mmddyyyy) and year-only dates (yyyy) in the same field?

2011-01-25 Thread Karen McNeil
Hello, I'm designing a model which is a collection of texts. Some of the texts will be things like books, with a date of publication, and some of them will be articles or transcripts with a mmddyyy date of publication/broadcast. I'd like to structure it somehow so that when I view the list

Re: Can I store full dates (mmddyyyy) and year-only dates (yyyy) in the same field?

2011-01-25 Thread Tim Sawyer
Hi Karen, I did with two fields - storing a date and a date resolution. The values could be: date / resolution - display value 1984-12-31 / Exact Date - 31st December 1984 1984-12-01 / Month - December 1984 1984-01-01 / Year - 1984 So I just used the first of the month where unknown, and Janua

Re: Can I store full dates (mmddyyyy) and year-only dates (yyyy) in the same field?

2011-01-25 Thread David
Malcolm Tredinnick gave a talk at Djangocon last year that touched on this. He used a similar approach to Tim. Essentially he had a model that had a DateField and a precision. Malcolm has his slides up: https://github.com/malcolmt/django-modeling-examples/blob/master/slides/modeling-challenges.pdf

Re: Can I store full dates (mmddyyyy) and year-only dates (yyyy) in the same field?

2011-01-25 Thread etienned
I had this need some time ago. You can check the answers of my question on stackoverflow for different avenues: http://stackoverflow.com/questions/2971198/how-to-deal-with-partial-dates-2010-00-00-from-mysql-in-django Etienne On Jan 25, 7:22 pm, David wrote: > Malcolm Tredinnick gave a talk at D