SQL Server: Working With Date but With Format of Your Own Choice

SQL Server expects date in MDY or it works fine with MYD and YMD. And it returns error, if you provide other then these format like DMY.A simple trick to resolve this problem.