× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



>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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.