SQL dates need to be in the format #mm/dd/yyyy# irrespective of the column
format. Access has only one data type for date and that is date.
Just do a query on dates in Access itself and then look at the SQL it
creates. That will show you the syntax. This is all SQL, not just Access SQL.
E.g. SELECT * FROM MyTable WHERE ADate = #11/10/2000#
Regards
Neil
At 11:19 10/11/2000 -0700, unni wrote:
>Hello,
>
>When I am trying to insert a date into MS Access database I am getting an
>error saying 'Data Type mismatch in criteria expression".
>I have the column as 'small date mm/dd/yy' format and I am inserting in the
>same format. Did any one have this problem before?
>
>Thanks.
>-Unni
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
