Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Negative dates in webi report when export to Excel

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

Former Member
Former Member replied

Hi,

My Excel (2007) has problems with dates before 1/1/1900.

I guess that's your problem too. When looking around the internet this is confirmed.

I would consider using an excel formula to handle this.

Marco

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question