import spreadsheet date returns 1900

[willykos]

When I import a spreadsheet from quattro, with a date in long international format the table returns a date of the year1900 not 2000.<br>
Hopfully there is a fix for this y2k problem, as all of our timecard data is setup to be imported to Paradox from quattro.<br>
<br>
P.S. Paradox version 8 and 9 are both the same.<br>
<br>
Thank you very much.<br>
Willy Kostenborder

 

[Alt255]

Qpro from version 2 and Paradox from version 3.5 both handle dates well beyond 01/01/2000. Is the problem only related to the date display?<br>
My guess is that Qpro is obtaining its data from an archaic system that returns only the last 2 digits of the year. Is the data obtained from hardware (eg. Winstar &lt;v.5.0) or from manual data entry?<br>
If the last case is true, your solution will be a piece of cake. Tell the operators that the year &quot;00&quot; never existed. We are in &quot;2000&quot; now.<br>