IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Filter based on date in MMDDYYYY format


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Prakash nadesan

New User


Joined: 05 Mar 2009
Posts: 3
Location: Bangalore

PostPosted: Wed Apr 21, 2010 12:06 pm
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Apr 21, 2010 3:15 pm
Reply with quote

Include records using relative dates at Smart DFSORT Tricks.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Apr 21, 2010 3:59 pm
Reply with quote

do not double post
people answering are the same in both forums!
Back to top
View user's profile Send private message
Prakash nadesan

New User


Joined: 05 Mar 2009
Posts: 3
Location: Bangalore

PostPosted: Wed Apr 21, 2010 5:14 pm
Reply with quote

I have refered the material already, but this doesnt have any solution for dates in MMDDYYYY format
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Wed Apr 21, 2010 5:24 pm
Reply with quote

Date calculation - is it possible?
Date calculation with DFSORT
Back to top
View user's profile Send private message
Prakash nadesan

New User


Joined: 05 Mar 2009
Posts: 3
Location: Bangalore

PostPosted: Wed Apr 21, 2010 7:11 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Need help to append a date&tsp at... DFSORT/ICETOOL 9
No new posts InfoSphere OPTIM CSV ouput vs DSNTIUA... IBM Tools 3
Search our Forums:

Back to Top