I also tried to achieve like this same. If some one help me to get the output for the following
I have a date on my input file which is record created date in table.
I have to calculate the number of days with the current system date. And if the number of days fall in 0-5 days then I have to write as A in the same file at the last column.
If the number of days fall in 6-10 days then I have to write as B in the same file at the last column.
So the output should be like as below if the system date is 05/26/2008.
With PTF UK90025 for z/OS DFSORT V1R10 and PTF UK90026 for z/OS DFSORT V1R12(Oct, 2010), DFSORT now supports date arithmetic which can be used to calculate the number of days difference between two dates. The result is an 8-byte value consisting of a sign and 7 digits (sddddddd). If the first date is greater than or equal to the second date, the sign is + (plus). If the first date is less than the second date, the sign is - (minus).