Dates not showing correctly

[darners]

Hope someone can help

I have a single table that I am bringing back from a sql 2012 database

In Framework Manager if I test the data I get the correct dates displaying

10 June 2015

When I run the report within Report studio I get

8 June 2015


I have attached the 2 screenshots

Any ideas gratefully received

[BigChris]

Could the Report Studio results be cached? I'd try clearing your cache in your browser and running the report again. I'm clutching at straws a bit here, especially given the exact time matching on the two records...

[darners]

Thanks for the reply, I did try clearing the cache

I gets even more weird now though

If I    day([field]) it gives me '10'

I am at a total loss

I have ended up extracting year, month, day from the original field and _maketimestamp(year,month,day)

That seems to do the trick. Not ideal but a work around until I find out why , and also check all other date fields

[bdbits]

I would pull the SQL from FM and from RS and compare. If they are identical, I would open a support ticket.

[darners]

Cheers, they were identical, PMR raised with IBM