Further on Michael's excellent advice, the CONVERT function takes the third optional parameter [style], controls the style of the input/output.

😎

select [Date] = CONVERT(VARCHAR(10),convert(date,'7/26/29',1),101)

Results

07/26/2029

European

select [Date] = CONVERT(VARCHAR(10),convert(date,'7/26/29',1),103)

Result

26/07/2029