MSSMS Error Conversion failed

Try it using suggestion here

And reading about try_convert. It will help you learn

Also look into CAST and CONVERT (Transact-SQL) - SQL Server | Microsoft Learn

for different date formats you can use. show us what you tried and then where you stuck after reading the above.