Unanswered: Date Format When Exporting in Paradox 8
I have a table in Paradox 8 which displays date fields with a 4-digit year, but exports in 2-digit year format. How can I reconfigure Paradox to export in 4-digit format? I tried creating a new date format by modifying the properties on the date column, but this only affected how the data is displayed, not the database structure. This causes a problem in Windows 2000, since it only recognizes two-digit year values as falling between 1930 and 2038 (Regional Settings). I have records with dates in 1901 that are being recognized as year 2001, when I import the table into MS Access. Any ideas?
(P.S.) It appears I cannot change the Regional Settings in Control Panel.