Darrell,

        What is with the '(' before the *GT and *LT?  There is no
closing ')' and no space between the characters.  This would convert
into;
'... *AND VLEFDT *GT("20070331" *AND VLEFDT *LT("20070325" '.  

Since VLEFDT is numeric you can just do something like this, VLEFDT *GT
20070331.

Thanks, Matt

<SNIP>
OPNQRYF    FILE((DTLRES)) OPTION(*INP) + 
             QRYSLT('VLCOCD=%RANGE("' *CAT &FCO *CAT + 
             '" "' *CAT &TCO *CAT '") + 

                           ***
                                   ***
                                    |
                                    V   
             *AND VLEFDT *GT("' *CAT &BEGDT *CAT '"   +   
             *AND VLEFDT *LT("' *CAT &ENDDT *CAT '"') + 
             KEYFLD((VLCOCD) (VLEFYY) (VLREIN) (VLRD) + 
             (VLTYPE) (VLCOVC)) 
</SNIP>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.