cancel
Showing results for 
Search instead for 
Did you mean: 

Date showing in Analyzer as number

Former Member
0 Kudos

After upgrading to NW04S, SP9, key figure with type DAT (Date field yyyymmdd) is showing up in NW04S Analyzer as a number instead of as a date. Instead of showing 12/1/2006, it is showing 39,052.

In RSRT, the same query shows the correct date of 12/1/2006 for this key figure but in Analyzer it isn't. Any ideas on fix to this? Thanks for your help.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

If I change my workbook Analysis Grid Properties to select option "Use Formulas" then my date shows up correctly (shows date instead of number) but it messes up my other columns. Is this the only way to get the date format to display correctly in NW04S?

Former Member
0 Kudos

Anil,

Our ABAP developer checked out this OSS note and said that we can't apply the correction unless we are on SP10 first. Thanks.

Former Member
0 Kudos

Anil,

Thanks for your suggestion but this OSS note #1019539 will not work for us. It requires that we be on SP10 first. We can't upgrade to SP10 so we can't implement this OSS note.

Thanks again for your input.

Former Member
0 Kudos

Hi,

You donot need to go with complete support package upgradation.Just implement the correctionc mentioned in the note,even though you are not at SP10.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi,

Check the correction instruction given in the note : 1019539 would help you.

With rgds,

Anil Kumar Sharma .P