Data type mismatch in criteria expression.
-
I would appreciate any help with the following error message. I'm trying to insert records into a ACCESS database. I would like to include a date field to insert query. I tried to convert it with Convert.ToDateTime(myDate) but it doesnt work. Only when i remove the parameters that holds the date value the query is OK. The Date is in good format. When I'm trying to run this query separately in ACCESS it works well. I'm a novice and may b this is boring stuff! ThanX.
-
I would appreciate any help with the following error message. I'm trying to insert records into a ACCESS database. I would like to include a date field to insert query. I tried to convert it with Convert.ToDateTime(myDate) but it doesnt work. Only when i remove the parameters that holds the date value the query is OK. The Date is in good format. When I'm trying to run this query separately in ACCESS it works well. I'm a novice and may b this is boring stuff! ThanX.
Insert/update your dates in following format: "YYYY/MM/DD HH:MM:SS". This always works on both Access and SQL Server, regardless on locale Philip Patrick Web-site: www.stpworks.com "Two beer or not two beer?" Shakesbeer
-
Insert/update your dates in following format: "YYYY/MM/DD HH:MM:SS". This always works on both Access and SQL Server, regardless on locale Philip Patrick Web-site: www.stpworks.com "Two beer or not two beer?" Shakesbeer