MSSQL - Fix Error - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Watch this example on YouTube

 

To fix it replace
Select Convert(datetime, '06122018')

with

Select Convert(datetime, Right('06122018', 4) + Left('06122018', 2) +
  Substring('06122018', 3, 2))