Alfonso
|
| Posted: 10/27/2002, 2:46 AM |
|
I have one problem when I search with date field. Into th e texbox, I write, for example 25/01/2002 (dd/mm/yyyy) and appears an error (in my case in spanish):
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][Controlador ODBC Microsoft Access] No coinciden los tipos de datos en la expresion de criterios.
/almarza/Common.asp, line 43
It is that data type are diferents. How can I Resolve this problem?
Thanks
|
|
|
 |
Nicole
|
| Posted: 10/29/2002, 7:12 AM |
|
Alfonso,
As I understand you’re using CC. In this case you should convert date into db date format before search on it or updating/inserting the record. Please refer to the following article for more details and sample format code: http://www.gotocode.com/art.asp?art_id=132&
|
|
|
|
|
