[78-L] 78 database

[David London]

Yes that works.  All this discussion has centred around text fields
expressing dates.  What I originally referred to was the problem of using a
proper database field with a date datatype.  I guess, because of the many
unknowns, a text field ends up being the better choice.  Eventually,
therefore, I need to parse the abarams files dates into the yyyy-mm-dd
format.

On Wed, Jul 7, 2010 at 3:25 PM, Steven C. Barr <stevenc at interlinks.net>wrote:

> Now to explain my methods a bit further...!
>
> I enter dates in yyyymmdd format (i.e. 19250622 for June 22, 1925).
> Where I don't have exact data, i substitute 99...thus 19259999 would
> indicate "sometime in 1925, but I don't know the month or day."
> This allows unknown dates to wind up at the end of years or months
> when I sort on date fields. Given the fact that I use my own "Dating
> Guide" I can usually estimate dates within a month or two (as well
> the Abrams Files usually show estimated dates with similar accuracy).
> A TOTALLY unknown date would be entered as19999999.
>
> Steven C. Barr
> _______________________________________________
> 78-L mailing list
> 78-L at klickitat.78online.com
> http://klickitat.78online.com/mailman/listinfo/78-l
>