• Not sure why you are trying to convert a string to a string and then to a date in the second part.

    But 103 is UK format, not 101. Try passing this into the datetime convert, not the varchar one.

    CONVERT(datetime, '18/05/2013', 103)