Hi Frank, all
A user has reported me an issue about a difference of 2 days between
Calc and Base when applying a date format.
To reproduce it :
- from a timestamp SQL (name : create_date, value : 1069773705)
- the formula ('create_date/86400)+ 25567.04167
- the origin is 25567.04167
The date format for display is JJ/MM/AAAA HH:MM:SS
Calc display 23/11/2003 16:21:45 and 30/12/69 01:00:00 as origin
Query in Base display 25/11/2003 16:21:45 and 01/09/70 01:00:00 as origin
It's under XP with m122. The database (created under OOo1.9.95) is made
of tables linked to a SQL database.
I've got a screen shot of to tables if needed. Alex told me that you
have already met this problem in old version and it's reappeared in dev
versions. I've search in IZ but didn't find the bug.
My questions :
- Is is really a bug or a wrong setting of date format somewhere ?
Kind regards
Sophie
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.1/64 - Release Date: 04/08/2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
