More paradox date stuff:
Regardless of Windows Short Date setting year as yy or yyyy if you enter the
date '1/1/45' into a grid you get
1/1/1945 but if you use an SQL INSERT of '1/1/45' you get 1/1/2045.
Similarly, a SELECT on '1/1/45' gets 1/1/2045.
FindKey([strtodate('1/1/45')]) will find 1/1/1945.
Windowing (1950 as pivot year) for SQL access, but same century as clock
date for direct access.
Solution: explicit century everywhere.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
