How to get correctly formatted Date when exporting BAQ results toi Excel

[Briser (Brian Sandison)]

I found a simple way to do this by virtue of another post:

Date format in BAQ Calculated Field

want this MM/DD/YY but keep on getting MM/DD/YYYY Thanks.

In my case I created a simple Convert(Varchar, mytable.myfield, 3) to get the UK format date dd/mm/yy and this shows up the same in Excel
Thanks to Brandon Anderson for that one. @Banderson