Two Digit Years in NT4 and Acc97 
Author Message
 Two Digit Years in NT4 and Acc97

I've got a customer that's run into a problem that seems to be related to
how the system interprets two digit years.

On other systems there's an option in the Regional Settings control panel
that set which 100 year period a two digit date will fall in. Its by default
1930->2029 so 01/01/01 is 2001 but 01/01/37 is 1937.  Now I've changed this
on my machine (WinME) but there doesn't seem to be a similar option for
NT4(sp6 I think)

How does NT4 interpret a two digit year and where can it be altered?

if the answer is badly and nowhere then how can I improve the code to use 4
digit years (which btw was Microsoft's answer: type the years as 4 digit,
which doesn't help because this is in code (in the datediff function)

the date is stored as long (4 digit) in the table but apart from that there
is only one piece of formatting done (which I can't test till tomorrow)

any suggestions?
Accommodation Software
"I refuse to have a battle of
wits with an unarmed person"

Tue, 22 Jul 2003 01:32:03 GMT  
 [ 1 post ] 

 Relevant Pages 

1. 4-digit years-ccyy in Cdate() (returned as 2-digit years-yy)

2. 4-digit year using VB4 and Access 2.0

3. VB5 4-digit year format and digital clock

4. Date function: Number of digits for the year.

5. date function format 2 digit year

6. 4-digit year using VB4 and Access 2.0

7. 4-digit year

8. Getting Four digits year in Vbscript?

9. 4-digit year using VB4 and Access 2.0

10. Year 2 digits vs date datatype/functions

11. How to always display years with 4 digits ?

12. how to force textbox to display dates using 4 digit years


Powered by phpBB® Forum Software