If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Approximate (Circa) Dates?
For a genealogy/family tree database some dates are
approximate. For example: my birthday is exact (January 1, 1970) and my ancestor's is not (just 1760). Some are "Before 1600" or "After 1433", some still are just "around 1830". Some just have month and year (Feb 1865). How would I create fields (or a field) to hold this? Setting it as straight string won't allow me to sort or search via range. Thanks a ton |
#2
|
|||
|
|||
Approximate (Circa) Dates?
I would make three separate fields. One for Month, One for Date, and one
For year. Don't format them as dates. You could always string them together to do date math. If approximate, maybe check a box? There are several boxed packages out there. You might look at some websites and see if you can get a demo copy or view screens on their webpages to see how they handle it. Rick B "Wolf" wrote in message ... For a genealogy/family tree database some dates are approximate. For example: my birthday is exact (January 1, 1970) and my ancestor's is not (just 1760). Some are "Before 1600" or "After 1433", some still are just "around 1830". Some just have month and year (Feb 1865). How would I create fields (or a field) to hold this? Setting it as straight string won't allow me to sort or search via range. Thanks a ton |
Thread Tools | |
Display Modes | |
|
|