How to subtract a constant from a date



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

How to subtract a constant from a date

Postby coollearner » Wed Jun 08, 2011 5:45 pm

I have a file with dates(mm-dd-yyyy)
e.g.,
02-04-2011
03-09-2010
05-07-1999

I want to subtract 999 from all these dates.
Please let me know how to do this.

Thanks In advance
Knowledge is wealth
coollearner
 
Posts: 33
Joined: Thu Jun 03, 2010 3:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to subtract a constant from a date

 

Re: How to subtract a constant from a date

Postby Frank Yaeger » Wed Jun 08, 2011 8:43 pm

What does 999 represent? Days, months, years, something else?

Show your expected output.

Give the RECFM and LRECL of the input file.

Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
RECORD
//SORTOUT DD DUMMY
//SYSIN    DD    *
    OPTION COPY
/*
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post