Re: Date conversion on chain

[Stuart Rowe <rowestu@xxxxxxxxx>]

Thanks, Booth, I could not remember the exact range!  I have not dealt with
non-*ISO dates in, well, probably since they were invented.

Stu




On Wed, Apr 16, 2014 at 1:19 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

> That looks like *HIVAL to me?  Can you chain with *hival?
>
> btw, the date field already knows what it is.  (The actual data in the
> field is not "9991231").  In other words, the H-spec is not telling the
> program the date's format; it is telling the program how to present it.
>
> btw2, 9999 is not in the range 1940 to 2039.  So the error message for
> *mdy is correct.
>
>
> On 4/16/2014 1:05 PM, Horn, Jim wrote:
> > I have a file that contains a date field with a value of 9999-12-31.  I
> > need to "chain" this record into a program that has an Hspec of
> > datefmt(*mdy).  I am getting error RNQ0114, Date or timestamp value not
> in
> > correct range.  If I change the program to datefmt(*usa) the chain works.
> >   The program specs say I need to use datefmt(*MDY).  Tried entering a D
> > spec with the field name with DATEFMT(*mdy).  Didn't work.  Any ideas?
> >
> > Jim
>
> --
> Booth Martin
> www.martinvt.com
> (802)461-5349
> Skype: booth.martin
>
> Activity makes more men's fortunes than cautiousness. -- Marquis de
> Vauvenargues
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.