Export analysis from obiee 12.2.1.4v to excel 2007+ time format displaying '######'

Question

Hi,

I try to export an analysis with time format to excel 2007+, but the field display is ##### or a number (for example -692892.514513889) that excel can't translate to hour.

The data format was custom, but also when I changed it to the default, it didn't export correct.

How can I solve this problem?

Thanks.

3827179 · Answer

Hi,

Just to update that finally I used the field as date type, I set the data format as HH:mm,

and the problem solved.

I think that the problem is with time field type.

3827179 · Answer

I can't upload screenshots because I work on computer that isn't connected to the net.

The column is date that in the rpd cast to time.

The first format i try with is custom HH:mm,
I try also don't override the default format or use suggest formats like [FMT:time] or [FMT:timeODBC] but it didn't solve the problem.

Joel Acha · Answer

What is the exact format of the Date Column? Does it have a custom date format mask? Is it an actual date column or a string with a date format? Some screenshots may be helpful in getting a better understanding of your issue.