Microsoft KB Archive/98361

{| = PRB: &quot;Operator/Operand Type Mismatch&quot; Error on BROWSE =
 * width="100%"|

ID: Q98361

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
 * Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SYMPTOMS
Comparing a date type field with a literal character string in the FOR clause of a BROWSE command may result in the error message &quot;Operator/Operand Type Mismatch.&quot;

RESOLUTION
To solve this problem, do one of the following:

  Use the CTOD function to convert the literal character string to a date type, as follows: USE invoices BROWSE FIELDS ino, cno, idate FOR idate > CTOD(&quot;05/22/90&quot;)   Place the date within braces ({}) as follows: USE invoices BROWSE FIELDS ino, cno, idate FOR idate > {&quot;05/22/90&quot;} 

MORE INFORMATION
This error is returned because a literal character string is a character type field rather than a date type field.

For example, the following statement

USE invoices BROWSE FIELDS ino, cno, idate FOR idate > &quot;01/01/91&quot; where &quot;idate&quot; is a date type field in the database, returns the above error. Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a errmsg compare curly brackets err msg KBCategory: kbprg kberrmsg kbprb KBSubcategory: FxprgBrowse
 * }