Cor Nouws wrote (19-11-2008 8:19)
A little test has been done with reference date: 13-12-1953 (DD-MM-YYYY)
Setting Resulting date
day offset .. in OOo Calc
30-12-1899 ... 14-12-2052
01-01-1900 ... 16-12-2052
01-01-1904 ... 15-12-2056
Try entering the date 1.1.1900 in your table (outside OOo), and check in
OOo: It should appear as "0" (since Base itself always uses a Null Date
of 1.1.1900). If that's not the case, the error is somehow on the driver
side (either OOo's or the ADO driver).
Indeed looks as if a driver is driving us mad :-\
A post at the forum (thread started after thread on this list) learned
about a trick to set the zero point of time calculation.
Needed for this particular case was 1800-12-28 00:00 .
So this issue is solved and made clear to me, that more or less 'at
random' off sets can be expected.
Regards,
Cor
--
Cor Nouws - nl.OpenOffice.org marketing contact
= "2008: The Year of 3" = www.nieuwsteoffice.nl =
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
