I'm having an issue with converting a date from YYYY-MM-DD to DD/MM/YYYY. When I put CONVERT(date,sh.Order_Date,101), it still comes back as YYYY-MM-DD. I tried changing the style to 102, 103, 104, 105, etc. and it keeps returning the same format each time. The data type for OrderDate is datetime, so I'm not sure what the issue is. I even tried convert(date,cast(OrderDate as date),101) and got the same result. Can someone help me?