Joined: 15 Feb 2005 Posts: 7130 Location: San Jose, CA
Sort products do not have any built-in functions for doing "arithmetic" on date fields, so you can't take a record with a date and add 1 to that date.
However, if you just want the current date + 1 in the form 'yyyymmdd', you can use this DFSORT job:
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
Anand78,
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 add/subtract days, months or years to a given date like shown below.
For complete details of date arithmetic functions and other new functions see "User Guide for DFSORT PTFs UK90025 and UK90026" paper (sortugph.pdf) at: