Option #3 was chosen. No choice. The mainframe app is a legacy app that can't be easily changed.
>>The whole app is SET CENTURY ON but the problem came when testing mainframe inport files where the date in the incoming delimited file is 2/29/00.
>>
>
>Yep... gonna be a problem. A few solutions.
>
>1. Get the text file in the format CCYYMMDD... it will import properly.
>
>2. Get a 4 digit date in the text file.... you will have to import the date as character, change the field type to date. G Takser posted some code for me in the 2.6 section a few months ago that does this.
>
>3. Import the field as text, expand the field, parse the dates and add a century value, probably based on some rollover. Then, change the field type to date.
>
>BOb
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05