SQL 2008 Stored Procedure date parameter

[jchewsmith]

I am trying to pass a date parameter to my sql stored procedure.

@BeginDate Date,
@EndDate Date

Select *
From table
Where [invoice Date] between @begindate and @enddate

I want to be able to enter into the parameter window
BeginDate 10/01/2015
EndDate 10/31/2015

but I am being forced to enter '10/01/2015' and '10/31/2015' for the process to work.

 

[bdreed35]

Can the procedure be changed? CR will recognize the SP parameters as actual dates, rather than strings, if you define them in the SP as DateTime type rather than Date.

~Brian