help with insert/updating date variables in table getting error Invalid cast from Boolean to DateTim

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when I am trying to insert in a table I am getting exception Invalid cast from Boolean to DateTime.
table (mdb) has variable defined as datetime as short date.
setting the variable as #01/11/1963#
Is there a special way to set date
thanks for your help.
 
when I am trying to insert in a table I am getting exception
Invalid cast from Boolean to DateTime. table (mdb) has variable
defined as datetime as short date.
setting the variable as #01/11/1963#
Is there a special way to set date
thanks for your help.
Click to expand...

Try using the following parameter (watch for text wrapping)

OleDbInsertCommand1.Parameters.Add(New
OleDb.OleDbParameter("DateTimeColumn", OleDb.OleDbType.DBDate, 0,
"DateTimeColumn"))

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com
 
Back
Top