handling incomplete dates

[Tom Farley]

All good suggestions in this thread. I haven't used "YY" dates for years.
I changed everything to "YYYY" in order to avoid the "YY" century issue.

Tom Farley

"Panorama Questions & Answers \(Discussion\)" <qna at provue.com> writes:
>For my club database, I use «Date of Birth» = ?(«Date of Birth» >
>today(),monthmath(«Date of Birth»,-1200),«Date of Birth») to make sure the
>Date of Birth is before today, even when using "YY". It will not work for
>our oldest member, but it did when I entered him, so that is good enough.
>
>Bruce De Benedictis
>
>>> If all you have is a year then maybe change all those to 01/01/YY so
>>> at least you have a valid date.
>> 
>> If it's more than 50 years old it will need to be 01/01/YYYY.
>> Otherwise, you will get a date in the twenty first century, instead
>> of the twentieth.
>> 
>> Dave
>> _______________________________________________
>> Qna mailing list
>> Qna at provue.com
>> http://provue.com/mailman/listinfo/qna