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