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