MVSFORUMS.com

[Sterling Price]

Is it possible to do arithmetic or calculate date intervals on dates and date constants using DFSort?

I've found lots of stuff on comparing dates in the docs, but so far have not been able to locate anything on calculations using dates.

In particular, what I'm trying to do is to find the month previous to the current month.

Thanks for any suggestions.

[kolusu]

Sterling Price,

DFSORT has the capability of performing arthimetic functions, but it cannot be used to calculate the differences between 2 dates, subtracting/adding 'n' days to current date etc..

You may find some examples here

http://www.mvsforums.com/helpboards/viewtopic.php?t=2432&highlight=add
http://www.mvsforums.com/helpboards/viewtopic.php?t=2212&highlight=add


Check this link for selecting records with date manipulations

http://www.mvsforums.com/helpboards/viewtopic.php?t=1459&highlight=date1

[Sterling Price]

My end goal is to produce a report with a title containing the previous month and the year, in the form:

August , 2004 (if the job ran in September 2004)

or

December, 2004 (if the job ran in January 2005)

[kolusu]

Sterling price,

The following JCL will give you the desired results. we use the DATE1 parm to get the current date in the format(YYYYMMDD). Since you want the month name of the last month , we use a change command to spell out the name of the last month. We also split the file into 2 files, when the month is 01 , we write it out to HDR1 file, else we write it out to HDR2 file.

When the month is 01, then we need to subtract 1 from the year to get the previous year. so at any point we will only create one header.Either HDR1 or HDR2 file.

[Sterling Price]

It worked perfectly. Thank you very much.