>>>The following statement works fine in Microsoft Query (accessing a SQL Server database):
>>>
>>>SELECT claim_number FROM DEDUCTIONS WHERE voucher_date=04/09/97
>>>
>>>It produces an Operator/Operand type mismatch error in VFP 5.0.
>>>
>>>The voucher_date field is type DateTime on the SQL Server.
>>>
>>>Any ideas?
>>>
>>>Jeff
>>
>>This should work if voucher_data is Date field:
>>>SELECT claim_number FROM DEDUCTIONS WHERE voucher_date={04/09/97}
>
>I am sorry: didn't read the question carefully. If type is DateTime the command should look:
>SELECT claim_number FROM DEDUCTIONS WHERE TTOD(voucher_date)={04/09/97}
Make sure you have an index on TTOD(voucher_date) to enable Rushmore