Re: Dates
Kevin Hauser (khauser@pcsrus.mv.com)
Thu, 22 Aug 1996 22:56:28 -0400
Glen Johnson wrote:
>
> One of the uses I thought I might try with my new Omnigo 100 (just bought 2
> wks ago) was to keep a mini-genealogy database. When I tried to enter a
> date such as 1855, the beeper goes, and you get /05 as the year. So I tried
> 2005 and that works OK, but 2104 gives me 2099.
>
> I'm not sure of the usefulness of the "date" entry anyway - Can one
> calculate number of days between two dates in a database? - Can the data be
> sorted by date?
Yes ... typically you can perform date calculations on date/timestamp
fields in a database.
For your purpose, you might be better off storing the date as separate
month, day, and year columns (each a number field) instead of using a
date field. Then, when you import the data in to your genealogy program
(a small assumption on my part), you can re-format it as needed.
-Kevin