Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there or isn't there?
Message
De
27/10/1999 17:07:15
 
 
À
27/10/1999 16:36:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00282613
Message ID:
00282690
Vues:
17
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform