out of range date and time value

Results 1 to 2 of 2

Thread: out of range date and time value

  1. #1
    Join Date
    Dec 1969

    Default out of range date and time value

    dtCurrent=date()<BR> set objRec = server.createObject ("ADODB.Recordset")<BR> strSQL="SELECT * FROM diary where category= &#039;meeting&#039; and dte <BR> = &#039;"&dtCurrent&"&#039; order by time"<BR> objRec.Open strSQL, objConn<BR><BR>i did this to get data about meetings that are held on the current date and this data should be order by time<BR>but the error message that i got was<BR>--------------------------------------------------------------<BR>Microsoft OLE DB Provider for SQL Server (0x80040E07)<BR>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.<BR>/diari/start page.asp, line 104<BR>-----------------------------------------------------------------<BR>line 104 is<BR>objRec.Open strSQL, objConn<BR><BR><BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: out of range date and time value

    what type of date field is dte? My guess would be it is not a short date. Date() will return 11/23/2001<BR><BR>Does dte have the time too?<BR>And, there is a field called "time" right?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts