|
>From my understanding, to a certain extent, what you said is true. However with a *YMD format, 060315 (todays date) is valid, but 031506 is NOT valid (there is NO 15th month). However, again from my understanding, the L field format *YMD of 060315 contains the same raw data value as the Lfield format *USA of 03152006. This can get really confusing!!! Alan Booth Martin <booth@xxxxxxxxxx om> To Sent by: RPG programming on the AS400 / rpg400-l-bounces@ iSeries <rpg400-l@xxxxxxxxxxxx> midrange.com cc Subject 03/15/2006 12:07 Re: date validate PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@midrang e.com> Is this statement true? I am still having a hard time getting my mind around the idea of an L field. Doesn't an L field store the date any way it wants to? Isn't the idea of the *YMD just to inform the L field what to expect? That the data coming in is in YMD, so it can differentiate between January 2, 2003, February 3, 2001, and March 1, 2002? Fisher, Don wrote: > You have to perform the TESTD before moving it to the date field. Since the > date field is in the *YMD format, any value placed in it must conform to > that date format. > > Donald R. Fisher, III > Project Manager > Roomstore Furniture Company > (804) 784-7600 extension 2124 > DFisher@xxxxxxxxxxxxx > > <clip> > I am getting this error cond. C > Date, Time or Timestamp value is not valid (C G D F). > <clip> > I defined this > D Datefield S D DATFMT(*ymd) > > I move the date from the screen to Datefield. The date on screen is > defined as num. 6 00. > > Then I do the TEST > <clip> -- This is the RPG programming on the AS400 / 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.