Date parameter as dd/mm/yyyy

USE [Girfa_StudentHelp]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create proc [dbo].[StuReport]

(

@d1 varchar(100),

@d2 varchar(100)

)

AS

BEGIN

     SET NOCOUNT ON;

           SELECT  * FROM  dbo.Student

           where convert(date,dbo.Productstock.createdate,103) between    convert(date,@d1,103)  and convert(date,@d2,103)          

     SET NOCOUNT OFF;

END

Next Example