-- Error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

foo = CONVERT(DATETIME, '27.04.2007', 102)