Dates showing up as 1900

[Meltdown]

Hi everyone, I'm working on a Pivot table and for some strange reason it's returning date values of 1900 even though the dates are all in 2003.

Has anyone ever come accross anything like this before?

I've attached a screen shot which might be of some help.

 

[IgorB]

I think you should try use function Format.
I had similar problem when exported field Time(hours,minutes,seconds) to Excel file.

 

[Meltdown]

Thanks IgorB, how did you Format the Date to solve the problem?