hi
iam geting error in running sql :

runtime error 2147217913(800040E07)

convertion of char datatype to smalldatetime datatype resulted in out of range samlldatetime value.

please help....
my sql is:

rs.Open "Select * from t_indent_det Where Indent_no = '" & ind_det.indent_no & "' and item_code = '" & ind_det.item_Code & "' and gsm = '" & ind_det.GSM & "' And S_Length = " & ind_det.S_LENGTH & " And S_Breath = " & ind_det.S_Breath & " And G_Direction = '" & ind_det.G_Direction & "' and Reel_od = " & ind_det.Reel_OD & " and mfg_code = '" & ind_det.mfg_code & "' and Core_ID = " & ind_det.Core_ID & " and Schedule_date= '" & ind_det.shedule_date & "'", dbconn, adOpenKeyset, adLockOptimistic

Based on the error message, one of your columns in your WHERE clause is of smalldatetime data type and the value you are trying to compare to it is either before January 1, 1900 or after June 6, 2079, which are the limits of a smalldatetime data type. Another possible cause of this error is passing an invalid date like '02/29/2007' or '06/31/2007'.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp

To me it looks like it is because the server accepts the datetime to be of mm/dd/yyyy as default format, and the value being processed is of dd/mm/yyyy format that causes this error.

Cheers.

_________________________
- Vijay G
Strive for Perfection