Re: Date data type question

[Jerry Keppler <kepplerj@xxxxxxxxxxxxxxxxxxxxx>]

Goodbar, Loyd (AFS-Water Valley) wrote:
> 
> I'm reengineering an application in RPG/IV, and I am using date data
> types extensively. A big problem I'm having is processing birth dates.
> Many people I'm processing have birth dates before 1940, so I get the
> error "The year portion of a Date or Timestamp value is not in the range
> 1940 to 2039." Is there anything I can do to use these dates with the
> date data type or must I still use a numeric format? Running V3R7.
> 
> Thanks,
> Loyd Goodbar

I ran into that too on our y2k project.  You are getting this error
message when you attempt to convert date data to *MDY or *YMD format. 
What I did to get around that was to convert it to *USA numeric 8,0.
then strip off the century portion of the year.  Most of the time I just
displayed it in an 8 digit format, but there were a few instances where
I didn't have enough room left to display the full 8 digits.

I think the reason you get this error when you attempt this, is that if
you try to convert back to an 8 digit year it will yield incorrect
results.

-- 
___________________________________________________________
Jerry R. Keppler      Pattonville School District
Computer Programmer   11097 St. Charles Rock Road
(314) 213-8045 Voice  St. Ann, MO 63074-1509
(314) 213-8650 Fax    mailto:kepplerj@pattonville.k12.mo.us
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---