The link is about converting from date formats rather than from a string.
You will need to get the parts of the date using Left() and Substring() then convert to date. If you have Server 2012 or later, you can then use DateFromParts() which is the SQL version of Access DateSerial(). Otherwise concatenate the parts you extract into a standard date string (yyyy-mm-dd) and Convert() from that to Date.