RE: Base year

You can add a 'sanity check' for dates in the future.  Your 2039 example can't 
be correct because it is in the future.  Probably 1939.  Of course, it isn't 
perfect but it would cut down the number of potential errors.

HTH,

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Karen L
Hodge/MIS/Genesys
Sent: Tuesday, February 14, 2006 2:03 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Base year


I am trying to convert a mm/dd/yy character field that contains date of
birth into a ccyymmdd numeric field.

When the character field contains a 2-digit year that is less than 40, and
it is moved to the numeric field, which has a 4-digit year, the century
used is 2000 and the 4-digit year becomes 2039, which is wrong.

Does anyone know of a way to change the base default for this?
If not, does anyone know of an easy way to correct this?


Thank you,

Karen Hodge
Senior System Analyst
Genesys Health System
1000 Healthpark Blvd, Grand Blanc, Mi 48439
Office 810.606.5180, Fax 810.606.7204
khodge@xxxxxxxxxxx


Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.