In VB 6.0, sql server 6.5,
Using ADO, I have a parameter:
.Name = msMeetingDate
.NumericScale = 0
.Precision = 0
.Type = adDBTimeStamp
.Size = 0
.Direction = adParamInput
But when I try to set it and execute the command object associated with
I get a "The conversion of char to smalldatetime resulted in a
smalldatetime value out of range"
So I tried adding an empty time to the end of the date"
Public Const gsNoTime = "12:00 AM"
.Parameters(msMeetingDate).Value = ssDate_OrderDate.DateValue &
Space(1) & gsNoTime
Set mrstOrders_For_Day = .Execute
ssDate_OrderDate.DateValue is equal to 5/22/00
But that didn't work.
Does anyone know how I can get this to work??
Thanks in Advance,
Laurence Nuttall - UCLA