I wasn't doing that. I think it was the crack. :)

>CREATE SQL VIEW mydateview AS ;
> SELECT * from mydatabase!mytable where dMyDate >= ?ldDateParameter
>
>ldDateParameter=DATE()
>USE mydatabase!mydateview
>
>It worked fine.
>
>Regards
>
>JR