Skip to Content
0
Former Member
Jun 04, 2011 at 12:32 AM

Negative dates in webi report when export to Excel

364 Views

Hi, I have a webi report with a column for a birth date. When exported to PDF, all date values are displayed correctly:

e.g

'10/3/07' for 10th Mar 2007

'10/10/50' for 10th Oct 1850

However, when exported to Excel, some of the values are displayed as '##########'. For the same values above these are displayed as:

03/10/2007

############

I am mostly concerned about the '#########'. Clicking on the cell reveals that the value is '-17979'... This only happens for some dates and not others. Is this a bug?

Appreciate your help, thanks,

Chi