casting a datetime to a date from Sql database in report studio takes off 2 days

[TSCognos1]

Hi when casting a datetime field from a SQL database to a date in cognos 1022 the result is always 2 days behind. Does anyone know why?

if you don't cast the item then it comes through fine

[MFGF]

Hi when casting a datetime field from a SQL database to a date in cognos 1022 the result is always 2 days behind. Does anyone know why?

if you don't cast the item then it comes through fine

I don't see that in my 10.2.2 instance over SQL Server 2012. What expression are you using? How are you connecting from Cognos to the database?

MF.

[BigChris]

I don't see it over SQL 2008 using 10.2.0 either. Are you just using

Code Select Expand

cast([DateTime Field],date)or something different?