|
Reggie, I think UPPWCD is a field from the file - not a CL variable. he'd have to do a *MAPFLD to substring out the file variable for comparison. Rick ------original message------- Ooops! Fat fingers. Try this... OPNQRYF FILE((JNORBUT/PWDEXPFILE)) OPTION(*ALL) + QRYSLT('%DATE(''%SST(&UPPWCD 3 2)||''/''||+ %SST(&UPPWCD 5 2)||''/''||+ %SST(&UPPWCD 1 2)'' >= + CURRENT_DATE - ''%DURDAY(30)''') (this hasn't been tested) HTH Reggie
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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 copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.