Connecting Tech Pros Worldwide Help | Site Map

SqlDateTime overflow when running procedure

poppy
Guest
 
Posts: n/a
#1: Nov 19 '05
I set up my parameters in code as follows :
Expand|Select|Wrap|Line Numbers
  1. lTTState.startDate = Today.AddDays(-10)
  2. lTTState.startDate = Today
  3. lSqlCmd.Parameters.Add(New
  4. SqlParameter("@startDate", SqlDbType.DateTime))
  5. lSqlCmd.Parameters("@startDate").Value =
  6. lTTState.startDate
  7. lSqlCmd.Parameters.Add(New SqlParameter("@endDate",
  8. SqlDbType.DateTime))
  9. lSqlCmd.Parameters("@endDate").Value = lTTState.endDate
  10.  
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
Guest
 
Posts: n/a
#2: Nov 19 '05

re: SqlDateTime overflow when running procedure


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

Lars-Erik

"poppy" <anonymous@discussions.microsoft.com> wrote in message
news:187301c54970$a9d60ef0$a401280a@phx.gbl...[color=blue]
>I set up my parameters in code as follows :
>
Expand|Select|Wrap|Line Numbers
  1. lTTState.startDate = Today.AddDays(-10)
  2. > lTTState.startDate = Today
  3. >        lSqlCmd.Parameters.Add(New
  4. > SqlParameter("@startDate", SqlDbType.DateTime))
  5. >        lSqlCmd.Parameters("@startDate").Value =
  6. > lTTState.startDate
  7. >        lSqlCmd.Parameters.Add(New SqlParameter("@endDate",
  8. > SqlDbType.DateTime))
  9. >        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 ?[/color]


Closed Thread