Hello anyone
I recently read post where people wondered how to subtract days to a date in a file. My question is, if I can subtract one date (as a parameter in the JCL) to another date within a file. I mean.
I have a file with many dates (yyyymmdd format). I need to subtract this date to another introduced by CONTROL-M (yyyymmdd format) and take the difference of days in another file.
I have the following dates in a file (fb=8)
20110112
20110114
20110320
20110322
20110512
.....
I want subtract one date (for example 20120131) to all records. My output file should be the difference in days (fb=8)
-10019
-10017
-9811
-9809
-9619
.....
How I can do? I also want to make the sign... I use ICE201I DFSORT (October, 2010 DFSORT functions)
Thanks a lot of