>Hi Trey.
>Nope. After deleting the ctod() now I got an Operandor/Operator type mismatch message, BUT, if I write the following in the command window:
>
>date1=ctod("09/17/2000")
>date2=ctod("09/19/2000")
>
>I can browse my view just fine. How can adapt this to the view's filter?
>
>Thanks for your time.
>
>Ulises
OK, couple more questions :)
Since the above works, I'm assuming the data type of the
Ventas.fechaonly
field is date.
So the problem must be with however the
date1
and
date2
variables are populated before being used by the view.
CTOD() used on a non-date variable results in the first error - Error 11: Function argument, value, type or count is invalid
Comparing a date type to a character type results in the above error - Error 107: Operator/operand type mismatch.
I'm guessing that at the point the
date1
and
date2
variables are being used by the view, they are neither of date type (for the
field=var
attempt) nor of the correct date string format (for the
field=CTOD(var)
attempt).
I would set a breakpoint in the code before the view is requeried and see what data type the
date1
and
date2
are.
HTH
Insanity: Doing the same thing over and over and expecting different results.