Compare Dates in SORT

[Mr Awasthi]

All,

I have a got a file in which one of the columns will have the dates in the MM/DD/YYYY.

Code: Select all

11/25/2015 
10/10/2015 
10/12/2015 
06/29/2015 
09/21/2015 
10/30/2015 
09/12/2015 
08/20/2015 
07/16/2015 
09/27/2015 
04/15/2010 
10/14/2015 
09/20/2015 

I need to get only those records which are older than today date. I used the following control statements.

Code: Select all

SORT FIELDS=COPY                            
INCLUDE COND=(1,10,LT,&DATE(MD4/)),FORMAT=ZD 
OUTREC FIELDS=(1,30)

but it gives a syntax error. Can someone please help me to correct it.

[William Collins]

Perhaps you should look up what &DATE is and where it can be used?

[Anuj Dhawan]

It's been a while when I used SORT but try with this, assuming your Input FB/80 (not teste):

Code: Select all

//SYSIN    DD *                                                    
  SORT FIELDS=COPY                                                  
  INREC OVERLAY=(81:7,4,1,2,4,2,DATE1)                              
  OUTFIL BUILD=(1,80),INCLUDE=(81,8,CH,LT,89,8,CH)                  
//*