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
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...
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
I would pull the SQL from FM and from RS and compare. If they are identical, I would open a support ticket.
Cheers, they were identical, PMR raised with IBM