|
View previous topic :: View next topic
|
| Author |
Message |
techslam
New User
Joined: 03 Dec 2010
Posts: 87
Location: India
|
|
|
|
Hello,
My Input file has date of births [LRECL=80]
| Code: |
RECORD1 1985-09-10
RECORD2 1975-09-10
RECORD3 1965-09-10
RECORD4 1955-09-10
RECORD5 1945-09-10
|
I need to subtract the birthdate in file from CURRENT DATE and check if the Difference is greater than value 00179999, and write only those record for which this condition is true. Can this be done using DATEDIFF funtion of DFSORT ?
Please guide me. Thanks |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
techslam,
New question, new topic please.
Did you try it out? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
i almost bothered to look it up for you
(the link that SKOLUSU provided,
www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000242
in the other thread that you originally posted this question),
but then I divided 00179999 by 365 and that was about 494 years
so you did not mean days, apparently.
WTH does 00179999 represent? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Possibly looking for people who are 18 or older . . .?
And locked?
d |
|
| Back to top |
|
|
|
|
