Re: date math in CL

["Booth Martin" <booth@xxxxxxxxxxxx>]

If you wish to stay within CL you might consider converting the date to *JUL
or *LONGJUL and adding your days, then converting that julian date back to
your desired format.
The julian date field needs to be changed to a *DEC intermediate field to do
the addition.
Monitor for an invalid date.  If the date is invalid then you've gone over
year end and need to add 1000 to the julian date and then subtract 365 or
366 (depending on whether or not its a leap year).

This may not be attractive but it works.
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: 04/21/04 15:46:58
To: Midrange Systems Technical Discussion
Subject: Re: date math in CL
 
Charles, Vern,
 
Thanks for the tips!  At first I thought CEE APIs were off-limits to CL
programs, but I looked at the CEE API docs a little closer and remembered
CALLPRC in CLLE programs!
 
If anyone's interested, here's a quickie sample program I did to test that
it works.  Buyer beware - there's no error checking or message monitoring
(but there will be in my production app!)
 
- GA
 
Pgm
 
   Dcl     &YYMDstamp   *Char  (    17    )
   Dcl     &ErrorCode   *Char  (    32    )  Value( ' ' )
   Dcl     &YYMDtoday   *Char  (     8    )
   Dcl     &LilDateHex  *Char  (     4    )
   Dcl     &fc          *Char  (    12    )
   Dcl     &LilDateNbr  *Dec   (     8  0 )
   Dcl     &YYMDnxtWk   *Char  (     8    )
 
/* Using IBM API, get the current system timestamp             */
   Call       QWCCVTDT  Parm( '*CURRENT  '  ' '  '*YYMD     ' +
                                &YYMDstamp  &ErrorCode   )
 
   ChgVar     &YYMDtoday  Value( %sst( &YYMDstamp 1 8 ))
 
/* Convert today's date to lilian date, so we can do date math */
   CallPrc    CEEDAYS  Parm( &YYMDtoday  'YYYYMMDD'  &LilDateHex &fc)
 
/* Convert Lilian date hex value to numeric, add 7 days, +
    and convert back to hex value again.                       */
   ChgVar     &LilDateNbr  Value( %bin( &LilDateHex ))
   ChgVar     &LilDateNbr  Value( &LilDateNbr + 7 )
   ChgVar     %bin( &LilDateHex )  Value( &LilDateNbr )
 
/* Convert Lilian date back to a normal character date         */
   CallPrc    CEEDATE  Parm( &LilDateHex  'YYYYMMDD'  &YYMDnxtWk &fc)
 
TEST:   DmpCLpgm
 
Endpgm