Try This :

Create procedure proc1

@orderstatus VARCHAR(15),

@orderdate DATETIME,

@createdate DATETIME

AS

Select * from table1

where ordercreatedt >= CAST(CONVERT(Varchar(10),GetDate()-1,120) AS DateTime)

AND ordercreatedt < CAST(CONVERT(Varchar(10),GetDate(),120) AS DateTime)

and orderstatus = case when @orderstatus = 'ALL' then orderstatus Else @orderstatus End

and orderdate = ISNULL(@orderdate, orderdate)

and ( @createdate Is Null Or convert(varchar(10),ordercreatedt,101) = convert(varchar(10),@createdate,101) )

Go