Page 1 of 1

Need help on SORT

Posted: Wed Apr 04, 2018 9:58 pm
by Navajyoti Baruah
Hi All,

I need a help from you to sort data from an input file based on the reference date present in it from column 55 to 62. My requirement is to sort out data which has been last referenced within 3 months.

Please note that the reference date is present in the format YY/DD/MM (e.g: 18/03/14 etc).

I have tried the below sort code but it works only when the date format is YYYY/MM/DD. But my requirement is to sort data from the input file which is in the format YY/DD/MM. So can anyone please help me
--------------------------------------------------------------------------------
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(55,8,CH,GT,DATE1(-)-90)
/*
--------------------------------------------------------------------------------[/img]

Posted: Fri Apr 06, 2018 6:55 pm
by Pk
Hi Navajyoti Baruah

Try this code and let me know if it is working for you ?

//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(55,8,Y2W,GT,Y'DATE1'-90)