>Hi,
>I have created a form allowing the user to enter the year. I would like to set a filter based on the year keyed by the user using the following code :
>
>"set filter to year(sales.date) = thisform.nyear.value"
>
>"nyear" is the value key in by users using textbox
>
>However, when I ran the form, "Operator/Operand type mismatch" error appear. I did a debug and find out that the value keyed by the user is Character. Is there anyway where I can change it to Numeric instead?
>
>Many thanks
set the initial value of the textbox to {}. This preformats it to date.
Erik Moore
Clientelligence