[RESOLVED] SQL Server 2008 - CONVERT

[Doogle]

I'm using the following:

ALTER PROCEDURE [dbo].[usp_CountStatusRounds] 
	@TableName sysname,
	@Date varchar(12)	
AS
BEGIN
	SET NOCOUNT ON;
	EXEC('SELECT COUNT(*) FROM ' + 
			@TableName + 
			' WHERE ' +
			'CONVERT (varchar(10), rndDate, 103) = ' + @Date 
	     )
END

Looking at the documentation for the CONVERT Function, the '103' should convert 'rndDate' to 'dd/mm/yyyy' format. However, it's converting to mm/dd/yyyy. Am I missing something ?