I have date1 value 2014-09-23. Now i want to add 9months to date1 and place it in date2 feild.
I was able to calculate 1 year to date1 but failed to add 9 months.
The below is sort card for adding one year.
OUTREC FIELDS=(1,317,318,4,ZD,ADD,+1,EDIT=(TTTT),322,29)
the file's total length is 350 bytes, our date feilds exists from 308 to 327 bytes.
If any one has idea how to do calculate the 9 months advanced date from given input value by using sort card, please let me know.
Appriciate your help.
********************************* TOP OF DATA **********************************
1 SYNCSORT FOR Z/OS 1.4.1.0R U.S. PATENTS: 4210961, 5117495 (C) 2010 SYNCS
EAST z/OS 1.13.0
SYNCSORT LICENSED FOR LICE
SYSIN :
SORT FIELDS=COPY
INREC OVERLAY=(308:30,10,318:30,10)
OUTREC FIELDS=(1,317,318,4,ZD,ADD,+1,EDIT=(TTTT),322,29)
OUTREC FIELDS=(1,317,318,4,ZD,ADD,+1,EDIT=(TTTT),322,29)
*
WER269A OUTREC STATEMENT : DUPLICATE STATEMENT FOUND
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
******************************** BOTTOM OF DATA ********************************
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
OK, you have SyncSort, whose questions belong in the JCL forum.
You are fairly current with SyncSort. Consult your documentation. You should find DATEADD which is of use to you if you can define "nine months" as a number of days.
If not, ask the analyst what is supposed to happen when you add nine months to 31 of May.
You need to know, exactly, what "nine months" means. These are computers, they know nothing themselves.