watch this example on YouTube
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.
To fix it replace
Select Convert(date, '07122018')
with
Select Convert(date, Right('07122018', 4) + LEFT('07122018', 2) + SUBSTRING('07122018', 3, 2))
