how to remove empty rows... (Date related)
In my query selection I have to select all records that has finish date less than current date. But some of the finish dates are 00/00/0000. How can I remove this from the result set from displaying it on the detail?. Bex does not allow variable with Between option where from date is '01/01/2001' to zvar_date. In other words Icannot mix constant and variable in a range selection.