Item analysis view entry: Date error

Deep

Dear All,

I am facing a strange problem in Item Analysis view entry.
My DB is SQL 2008 and NAV 5.0 SP1.

I have created an analysis view for Inventory, and when I update the analysis view, the date in Item analysis view entry is being updated as 31/10/2010.
I have given starting date as 01/11/2009, and transactions are there starting from November 11 2009.

The same error is being encountered in sales analysis view, which is updating different dates in 2010 for the entries which lie in 2009.
My purchase analysis view has been updated correctly.

I am unable to track where the problem may be.

Your help is appreciated.