Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there or isn't there?
Message
From
27/10/1999 17:07:15
 
 
To
27/10/1999 16:36:02
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00282613
Message ID:
00282690
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform