Problem with queries with DATETIME

[NareshShroff]

Hi,
i have a question related to DateTime date type.
1. how can i retrieve rows related to particular date.
i tried using the following statement but im getting syntax error.

Create procedure opentasks
{
@activedate as datetime
}
AS
Select Count(*) from tasks where activedate = @activedate
GO

what is wrong in above procedure?
can anyone help me out
Thanks in advance

[sanereddy]

what is the data type for activedate

[NareshShroff]

datetime

[sanereddy]

try this ....

Create procedure opentasks
@activedate as datetime
AS
Select Count(*) from tasks where activedate = @activedate
GO