PowerPivot date issues - Help!

[tommyb]

Hi all,

I'm getting an annoying issue with date formatting with PowerPivot and Excel. When I create a pivot from the PowerPivot workbook itself, the dates are correct in UK format. However, when I access the PowerPivot model as an OLAP cube stored in Sharepoint, the dates appear as US format.

Has anyone come across this issue before? And.. more importantly, does anyone have a solution?

Thanks in advance

 

[tommyb]

This problem is still happening! Can anyone help please??