an example of a substring statment … quick reponse… Think this is what you’re looking for….
CHGVAR VAR(&USRDTA) VALUE(&DAY || ‘-’ +
|| %SST(&JOBDATE 1 4))
You can use MAPFLD on OPNQRYF cmd to create new fields of 6,0 based on the date fields of the file and then use these fields on QRYSLT.
REGISTER or login: