>I have a view with a single parameter based upon a date field. My problem is that I would sometimes like to pass a parameter that returns all records. I have tried passing an empty date, but that returns only records which contain and empty date field.
>
>When I have views with a single parameter based upon a character field, I am able to pass an empty string and all records are returned. How do get the same result when I am dealing with a date parameter?
>
>Thanks in advance
I do this doing the following as my filter in the view:
Normally you would set it up as:
Table.DateField = ?vp_date
and the vp_date would have to be a date, but you can do this:
DTOC(Table.DateField) = ?vp_date
Then the vp_date can be a character string and thus can be blank to find all records. Try this and let me know.
HTH
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope