SQL Execute Command Datetime Formatting Issue

Hi,

I need to execute some store procedures I have in the SQL editor but I seem to  been having problems with the formatting for datetime variables needed for the execution of my code. can anyone please help?

 thanks in Advance

 

exec [usp_CMSTemplateCreateNewTemplate] 0, 0, 'My First Page', '', 0, CAST(10/16/2007,DATETIME), CAST(10/25/2007, DATETIME), 0, @PageTemplateID=0

 

THE STORED PROCEDURE SAMPLE

ALTER PROCEDURE [dbo].[usp_CMSTemplateCreateNewTemplate]

@SiteID AS INT,

@PageID AS INT,

@Title AS NVARCHAR(50),

@EditHREF AS NVARCHAR(512),

@CreatorID AS INT,

@StartDate AS DATETIME,

@EndDate AS DATETIME,

@Child AS INT,@PageTemplateID AS INT OUTPUT

AS