You may have to strip out the 'nd', 'rd' from April 2nd, April 3rd etc using REPLACE.

See CAST AND CONVERT in MSDN for a full description