In case anyone is interested in this, i found the solution. Instead of using the date field itself in the parameterized view, i use instead the DTOS function. My param. where clause looks now something like this:

...where dtos(myfile.mydate)=?pDate ...

When setting some date, i use dtos(somedate) as pdate, and when sending the empty string, this brings me the result for all dates.

>Hi
>I have a parameterized view with many parameters, that i requery throughout my program. When i want all the values for a specific parameter, i empty it and requery, and this works great. The only problem is that one of the parameters is of type DATE, and when i put in an empty date and requery, it does not show the records for all dates ( wich is what i want ), but i think that it brings me the results for the empty date itself ( i.e no records ). I cannot set it to .NULL. neither, since this will trigger an operand mismatch error...Is there a way ( some value for the date param. for instance ) that i don't know about to bring in the values for all dates in a requery?
>
>TIA
>Jaime