>>>>>I would like to have a view parameter that works like a logical, but uses a date field. I have a date field that is either empty or has some value. I would like to bring down the records that are either empty or have some value (regardless of what the value is). Is there some way I can set up a view paramter off of the date field to provide this functionality, or do I need to create another logical field?
>>>>
>>>>It's enough to use datefield equal {} (or NOT equal {}).
>>>
>>>How do you do that in a view parameter? You can't set the value of a view parameter to an expression.
>>
>>Why do you use 'expression'. You should just select datefield as 'Field Name' (View Designer: Selection Criteria tab), and type {} in 'Example'.
>
>That works if I always want the records with the date field being empty. I want the user to be able to choose (ie. parameterized) between empty and !empty.
I think the simplest way is to use programmatic Select ... into Cursor, or you can use two views.
Edward Pikman
Independent Consultant