The string was not recognized as a valid DateTime.
I get this error message: The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.
System.FormatException: The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.
May I know how I can solve the problem? Any assistance will be very much appreciated. Thank you
Below is pat of the code:
OleDbCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PARAM_BOOK_END_DATE", System.Data.OleDb.OleDbType.Date, 16, System.Data.ParameterDirection.Input, False, CType(19, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, "2003/04/23"))
OleDbCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("PARAM_BOOK_START_TIME", System.Data.OleDb.OleDbType.VarChar, 4000, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, "1000"))
1 Attachment(s)
Problem passing values to store procedure
Thank you so much for your help. I tried to change all the date format to this #4/24/2003# but the error seems to persist.
I just realised that I have a bigger problem. I'm not sure where is the source of the error.
I tried passing in the values(pls see attached file:sp.txt: source code) to the parameters. I get error 1(see attached file sp.txt: error 1)
When I change the value PARAM_COMP_END_DATE from "NULL" to #4/24/2003#, I get a second error(see attached file sp.txt: error 2)
May i know how to solve this problem? Any help will be greatly appreciated.:)