Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Date difference of 40 days

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
trushant.w

New User


Joined: 22 Sep 2013
Posts: 81
Location: pune india

PostPosted: Wed Jan 15, 2014 3:57 pm    Post subject: Date difference of 40 days
Reply with quote

In my input file i have two dates (both layout PIC 9(009) COMP-3.)
I want to extract records where date difference id 40 days.Please let me know if this can be achieved using sort.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Wed Jan 15, 2014 4:11 pm    Post subject: Reply to: Date difference of 40 days
Reply with quote

Have you looked at DATEDIFF? Examples in this forum, the manual, the internet, etc.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts how to add date & timestamp to th... dharmaraok DFSORT/ICETOOL 3 Thu Apr 18, 2019 2:45 pm
No new posts HEADER1 with Date arithmetic Martin-2000 DFSORT/ICETOOL 4 Thu Feb 21, 2019 3:24 pm
No new posts Relational operator compare date rang... maxsubrat CLIST & REXX 14 Wed Feb 06, 2019 6:19 pm
No new posts Regression testing of date format con... prino CLIST & REXX 0 Fri Jan 11, 2019 5:39 am
This topic is locked: you cannot edit posts or make replies. Add 5 days to a date Ron Klop DB2 19 Wed Jul 25, 2018 8:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us