Dlist Date format to Numeric returns Wrong Values

[SameerK]

Hi All,

in Planning Analyst 10.1,  I created a Dlist and formatted it as Date MM/DD/YY. I created a cube using the Dlist in combination of another Dlist. Now I entered a date in this cube as 09/25/12 and the cube saves it 09/25/12. Now, I edit the Dlist and format it from Date to Numeric and save it. Now when I reopen the cube that date value becomes 41179. But, the ms excel numeric equivalent of this date is 41177. So, cognos analyst is certainly 2 numbers off. I was wondering if anyone has come across this. Any info is greatly appreciated.

Thanks,
Sameer

[amoljcep]

I replicate Same scenario on cognos 8.4 analyst.  As cognos stores numeric value for date start from 01/01/1900 is 0 and the date provided has return me 41175 instead of 41177 or 41179.  As you are comparing this with Excel of which index start at 1 instead of 0 for storing date that is 01/01/1900.  This index numbers assists to get difference between date.