How to filter out the data by YYMM(year and mon using DFSORT

mkk157 · Active User Joined: 17 May 2006 Posts: 310

In my Input file i have Multiple months data ,, How ever i want to copy all the records from Only previous month. I.e If iam running job on July , i want to copy all the records only belowngs to June..

MY input File has like bwlow..

140428
140429
140505
140505
140507
140527
140604
140604
140609
140609
140609
140610

Output if iam running on july :

140604
140604
140609
140609
140609
140610

I have tried using Below card ,

SORT FIELDS=COPY
INCLUDE COND=(32,4,CH,EQ,Y'DATE2'-1)
But It is not copying any records,

Bill Woodger · Posted: Tue Jul 15, 2014 4:53 pm

DATE2 is YYYYMM. So if you compare that with a four-byte field, you are just comparing the YYYY part, so are unlikely to get the result you want.

YY dates are sooooooooo last century. Do you only have YY dates?

mkk157 · Active User Joined: 17 May 2006 Posts: 310

Issue is resolved now.....

SORT FIELDS=COPY
INCLUDE COND=(32,4,Y2T,EQ,Y'DATE2'-1)

mkk157 · Active User Joined: 17 May 2006 Posts: 310

HI Bill,

Yes , I have only YY... How ever DATE2 is Different than Y'DATE2'

Y'DATE2',
Y'DATE2'-m,
Y'DATE2'+m format is Y'yymm'

Please Correct me If iam wrong...