Thread: Dates and year 2000

Dates and year 2000

From
"Andy Marden"
Date:
Am loading date fields from text in one table to date in another. Format of
the text dates is 'DD.MM.YY', so that's the format mask I use. Dates for
2001 work OK - '02.09.01' translates as '2001-09-02', but '02.09.00'
translates to '0001-09-02 BC'! The y2k.html part of the integrated doc says
that 70 - 69 equates 1970 - 2069.

Am I missing something?

Version 7.1.3 on RH 7.2 BTW

Cheers

Andy