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.
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?
Add a comment