Hi,
Thanks in advance.
I am getting the following error (see below error message for more info) when performing an Advanced search with Date as criteria (it also happens on normal search):
**
Technical information
Error number -2147467259
Error description SQLState: 22005
Native Error Code: -3030
[INTERSOLV][ODBC SequeLink driver][ACCESS][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
URL /tblEnquiry_list.asp
SQL query select [EnquiryID], [EnquiryDate], [AssignedConsultant], [Status], [LoanType], [LoanAmount], [Surname], [FirstName], [HomePhone], [Mobile], [Email], [CurrentSuburb], [Referral] From [tblEnquiry] where 1=1 and EnquiryDate>='03/03/2005' and EnquiryDate<='03/05/2005'
This error only occurs when I upload the database to the web, it works okay on my own computer.
All other search criteria work except for date.
I am presuming it is because the date is being imported in a text format rather than date format, but do not know how to change it.
I have tried input=date and validate
<td><input type="date" size=20 name=SearchFor validate=date></td>
but without success.
If anyone could assist, that would be great.
Regards
Julie
www.simply-access.com
