The string was not recognized as a valid DateTime.

[evelin]

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"))

[Lunatic3]

You get error in the first line? Is it the Wizard generated code?

Try #2003/04/23# instead of "2003/04/23" and see if it helps.

[evelin]

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.

[Lunatic3]

OleDbParameter has six overload methods but your definision matches none of them. You have left the source column for all of them as blank. Let the wizard generates you the code and compare them.