The Calculate Date Difference 4 command is like CLCDATDIF3, but
allows a list of one or more day names to be specified. This allows
an answer to a question such as 'How many Tuesdays and Thursdays
exist between 2 dates?'
A typical series of commands would be:
DCL &DAYS *DEC LEN(7 0)
.
CLCDATDIF4 FROMDATE(010109)
TODATE(030209)
DAYNAM(*TUE *THU)
FROMFMT(*MDY)
NBROFDAYS(&DAYS)
The &DAYS parameter is a return variable and would contain the value
17.
The first day of 2009 is a Thursday. If you specify the first day of
2009 as both the From and To date and DAYNAM(*THU), the answer will
be one. Unlike CLCDATDIF3, the number of days between the two dates
is considered to be one.
CLCDATDIF4 escape messages you can monitor for
----------------------------------------------
TAA9892 The From Date must be *GE the To date
Escape messages from based on functions will be re-sent.
CLCDATDIF4 Command parameters *CMD
-----------------------------
FROMDATE The From date. It must be a valid date according to
the FROMFMT parameter.
The special value *TODAY may be entered to mean the
system date. If *TODAY is entered, the FROMFMT
parameter is ignored and the date is converted based
on the system date format.
TODATE The To date. It must be a valid date according to
the TOFMT parameter.
The special value *TODAY may be entered to mean the
system date. If *TODAY is entered, the TOFMT
parameter is ignored and the date is converted based
on the system date format.
DAYNAM A list of one or more day names such as *SUN, *MON,
... *SAT. *ALL may be specified for all days of
the week.
FROMFMT The format of the From date. *JOB is the default
meaning the date is in the format of the DATFMT
setting of the job. Other values include *SYSVAL,
*MDY, *DMY, *YMD, *MDYY, *DMYY, *YYMD, *JUL,
*LONGJUL, *CYMD, *ISO, *USA, *EUR, and *JIS.
TOFMT The format of the To date. *FROMFMT is the default
meaning the value of the FROMFMT parameter. *JOB
may be specified to mean the date is in the format
of the DATFMT setting of the job. Other values
include *SYSVAL, *MDY, *DMY, *YMD, *MDYY, *DMYY,
*YYMD, *JUL, *LONGJUL, *CYMD, *ISO, *USA, *EUR, and
*JIS.
NBROFDAYS The difference in number of days between the two
dates. This is a required return variable and must
be declared as *DEC LEN(7 0).
Restrictions
------------
Because CLCDATDIF4 returns a variable, the command may only be
entered into a CL program.
Prerequisites
-------------
The following TAA Tools must be on your system:
CHKDUPLST Check duplicate list
CVTDAT2 Convert date 2
DIVIDE Divide
EXTLST Extract list
RTVDAT Retrieve date
SNDESCINF Send escape information
SNDESCMSG Send escape message
Implementation
--------------
None, the tool is ready to use.
Objects used by the tool
------------------------
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
CLCDATDIF4 *CMD TAADAUR QATTCMD
TAADAURC *PGM CLP TAADAURC QATTCL
|
