Hi *,
I'm looking at a problem with data in an OOo Datasource.
It is about an MSDE-database running on Win 2000 Pro US SP4 Version
5.00.2195.
That is used as source for an OOo (2.4 on Win XP SP3 version 5.1.260)
datasource with use of the Microsoft Access Driver version 4.00.6305.00.
Now the problem: dates come in the OOo datasource as numbers.
Importing the fields in Calc, and setting the cells to a date format,
converts the numbers to a date, but a wrong one. There is some
regularity in the off-set, but not fully. As far as seen in the
investigation:
Difference in years is 99 or 100
Difference in month = 0
Difference in days is 1 or 2.
Does anyone have a clue where to localize the exact problem or how to
solve it?
Thanks a lot,
Cor
--
"The Year of 3" -2008- "Het jaar van 3"
Cor Nouws - Arnhem - Netherlands
> marketing contact - http://nl.OpenOffice.org
> Zeker van OpenOffice.org - www.nouenoff.nl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
