Convert() Help...

How can I convert a date to MMDDYY with Convert()?There is no standard conversion to do it.

Try this:

REPLACE(CONVERT(nvarchar(20),YourDate,1),'/','')|||You could also use DatePart 3 times. Just a different approach.|||thanks! Looks good..