Date format problem

[Petbul]

Hello,
I have problem with date field - after scheduling into Excel - there is something like ########### ...in time field - if doubleclick on this cell - excel displays some strange number (like 4292609878... .
In designer - this field is displayed correctly...
The field type in DB is DATE (length 8).

I am using following formulas :
Date ({MSF071_ROZDILY.T0}) - this field is OK
Time ({MSF071_ROZDILY.T0}) - this field is corrupted...
Any idea what's wrong?

 

[synapsevampire]

Perhaps if you select format->Cells and change it to time?

It appears that your dataqbase isn't storing a time, only a date (based on the fact that it's called a DATE< and not a DATETIME.

Make sure that you have the latest hot fixes installed from CR, they often address exporting.

To allow people to help you better in the future, post specifics, such as version of SI, and the type and version of the database.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Petbul]

Formating of cels in Excel does not help me...The cell has already format of time...

DB is storing date and time - e.g.- 2.1.2002 10:29:00
We are using Oracle 8.1.6, Seagate Info 7.02.100.
Petr