>>>Hi All
>>>
>>>Can I use two filters something like this?
>>>
>>>use customer
>>>set filter to country = "USA" .and. name="John"
>>>
>>
>>That works, yes, but since the syntax is (as you correctly have it)
>>
Set Filter To Expression
,
>>your example is actually one filter because
country="USA" and name="JOHN"
is the expression.
>>Make sense?
>
>OK, but my filter is actual
>
>
> set filter to periode = jaar.periode .and. datum = cdow(dDatum)
>
>
>jaar.periode is numeric and dDatum is a date
>I got the error Operator/Operand type mismatch
Did you really mean cdow() or did you want dtoc()? If it is dtoc(), this assumes datum is a string. If you want to compare a date field with a date variable, then it's just plain datum=dDatum.
HTH
Why do programs stop working correctly as soon as you leave the Fox?