Re: Date Conversion

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Interestingly, the code formatting is just fine in Firefox.  In IE8, the 
scrollable box (it uses a class "brush:text") shows up as only a single 
line.

Joe

> I think this is because the *LONGJUL format is YYYYDDD, where the DDD
> part is the day number, from 1 to 366.  So, Jan 02, 2012 converts to
> 2012002.  Subtract three from that and you end up with 2011999, which is
> an invalid date.
>
> Date math in CL is tough.  Scott wrote an article some years ago about
> using APIs.  Another option is to call an RPG program, since dates in
> RPG are really easy.
>
> Here's Scott's article (although the code formatting isn't very good):
>
> http://www.systeminetwork.com/article/rpg-programming/date-math-in-cl-61339
>
> Joe
>
> > Hi Folks,
> >
> > I converted the system date to jul with this cmd;
> >
> > CVTDAT     DATE(&SYSDAT) TOVAR(&CURJUL) FROMFMT(*MDY) TOFMT(*LONGJUL) TOSEP(*NONE) and the joblog shows this;
> > CVTDAT     DATE('010212') TOVAR(&CURJUL) FROMFMT(*MDY) TOFMT(*LONGJUL) TOSEP(*NONE)
> >
> > Then, I minus 3 days from the above date (-3) and then try to CVTDAT back to *YYMD but when I try to convert back to *YYMD the joblog shows;
> >
> > CVTDAT DATE('2011999') TOVAR(&PRVDAT#) FROMFMT(*LONGJUL) TOFMT(*YYMD) TOSEP(*NONE)   and I get CPF0555.
> >
> > Why does the -3 convert to 2011999 and how can I correct the date conversions?
> >
> > Thanks, Frank