P
poppy
I set up my parameters in code as follows :
My dates are declared as datetime in the procedure.
When I run the application I get the following error :
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM
and 12/31/9999 11:59:59 PM.
Any Ideas ?
Code:
lTTState.startDate = Today.AddDays(-10)
lTTState.startDate = Today
lSqlCmd.Parameters.Add(New
SqlParameter("@startDate", SqlDbType.DateTime))
lSqlCmd.Parameters("@startDate").Value =
lTTState.startDate
lSqlCmd.Parameters.Add(New SqlParameter("@endDate",
SqlDbType.DateTime))
lSqlCmd.Parameters("@endDate").Value = lTTState.endDate
My dates are declared as datetime in the procedure.
When I run the application I get the following error :
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM
and 12/31/9999 11:59:59 PM.
Any Ideas ?