• Another way to do it is:

    Convert(char(8),dteShipped,1)

    This will convert the date to a mm/dd/yy format.