SqlDateTime overflow when running procedure

[poppy]

I set up my parameters in code as follows :

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 ?

[Lars-Erik Aabech]

What exactly is the values of lTTState.startDate and lTTState.endDate?

Lars-Erik

"poppy" <an*******@discussions.microsoft.com> wrote in message
news:18****************************@phx.gbl...

I set up my parameters in code as follows :

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 ?