View previous topic :: View next topic
|
Author |
Message |
Prakash nadesan
New User
Joined: 05 Mar 2009 Posts: 3 Location: Bangalore
|
|
|
|
Hi, I have a requirement where my input file has date in MMDDYYYY format and i have to sort and include only the records which has date < currentdate - 28 days in the output file. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
do not double post
people answering are the same in both forums! |
|
Back to top |
|
|
Prakash nadesan
New User
Joined: 05 Mar 2009 Posts: 3 Location: Bangalore
|
|
|
|
I have refered the material already, but this doesnt have any solution for dates in MMDDYYYY format |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
Back to top |
|
|
Prakash nadesan
New User
Joined: 05 Mar 2009 Posts: 3 Location: Bangalore
|
|
|
|
Hi,
This sort worked.
Code: |
//SYSIN DD *
SORT FIELDS=COPY
INREC OVERLAY=(52:5,4,1,2,3,2)
OUTFIL INCLUDE=(52,8,CH,LE,DATE1-28),BUILD=(1,51)
/*
|
Thanks All. |
|
Back to top |
|
|
|