Dates prior to 1/1/1930

[Paul Scott]

Can anyone tell what I need to do to display a date prior
to 1/1/1930?

Thanks,

Paul

 

[John Vinson]

Can anyone tell what I need to do to display a date prior
to 1/1/1930?

Thanks,

Paul

Use a four digit year format (and, if you use date masks at all, a
four digit mask for the year).

Two digit years are assumed to be between 1930 and 2029, but you can
enter four digit years in the range 100 AD through 9999 AD.

 

[Marshall Barton]

Can anyone tell what I need to do to display a date prior
to 1/1/1930?

Use four digit years. Instead of entering a date as 1/22/04
(which is converted to 1/22/2004), enter 1/22/1904.

Two digit years up to 29 are assumed to be in the 21st
century, so 00 thru 29 is 2000 thru 2029, but 30 thru 99 is
1930 thru 1999.

 

[MyndPhlyp]

Use four digit years. Instead of entering a date as 1/22/04
(which is converted to 1/22/2004), enter 1/22/1904.

Two digit years up to 29 are assumed to be in the 21st
century, so 00 thru 29 is 2000 thru 2029, but 30 thru 99 is
1930 thru 1999.

Or ...

.... get creative with VBA. Since you know what the date is used for, you can
do the 2-digit to 4-digit conversion for the user and store it as a date
behind the scenes. You'll just be displaying it as text.

For example, if you know the date is a birthday, you know it will always be
in the past. As long as you know the birthday will never be more than 99
years ago, you can assume anything from "00" to "03" is 21st century and
"04" to "99" is 20th century.

If the date could be in the future and could be in the past, start thinking
in terms of just how far in the future or past the date might be and develop
a "sliding window" to frame the date range. You might, for example, allow 50
years forward and 49 years backward ... or 10 years forward and 89 years
backward.

And then, of course, if the date is in the future ... well, you get the
idea.

Very troublesome to have to bother with - you'll have to do all the
formatting, range checking and object manipulation to get it to "act" like a
date - and the rules might change causing you to rewrite bits and pieces.
But it's all for the love of the users whom we cherish so deeply and hold
with high regard. The users of old really got spoiled by 2-digit years. It's
something I hate to take away from them.

 

[John Vinson]

For example, if you know the date is a birthday, you know it will always be
in the past. As long as you know the birthday will never be more than 99
years ago, you can assume anything from "00" to "03" is 21st century and
"04" to "99" is 20th century.

Ah, but that leaves out my friend Lida who was born in '97. She still
comes to church occasionally. I am going to try to find out if she has
a great^n grandchild born in '97, I suspect she does.

 

[MyndPhlyp]

Ah, but that leaves out my friend Lida who was born in '97. She still
comes to church occasionally. I am going to try to find out if she has
a great^n grandchild born in '97, I suspect she does.

1897 for Lida, I presume. It would be quite the coincidence if Lida did have
a great born in 1997 and her name was also Lida. I have an uncle who hit the
100 mark within the last half year.

There is a down side when it comes to those centurions, and it seems we're
getting more of them every day. I think I failed to note that in my
diatribe. It could also be a problem if a security or debt were to mature in
100 years.

Of course, I'm sure you realize I was only illustrating (rather poorly)
that, if the date range is within a 99 year window, it is possible to retain
the old 2-digit year format for data entry. I'll consider it just a friendly
flame. <g>