I had the same issue, spent hours trying to sort it.

In the end i sorted it.

Using the T-SQL CAST Function, CAST the Datetime...