SSRS DataType Conversion: char data type to a datetime

Conversion: 
of a char data type to a DateTime data type resulted in an out-of-range DateTime value. It happens because of the date format in table in this format: 2009-01-09 00:00:00.000

You can use CONVERT(varchar, GetDate(), 103). Here 103 is UK regional DateTime format

CONVERT(data_type(length),expression,style)

Value	Description
data_type(length)	Specifies the target data type (with an optional length)
expression	Specifies the value to be converted
style	Specifies the output format for the date/time