Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from blah.txt type sdf -- y2k issue
Message
De
04/09/1999 17:27:11
 
 
À
01/09/1999 16:46:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00260279
Message ID:
00261550
Vues:
23
>I'll be doggoned, you are right! I can duplicate the problem in VFP 6 SP3 for any dates in the format mm/dd/yy --- in fact, all of them with non zero years come out with 00 as the century.
>
>I guess a workaround to this would be to change the date field to a character field. Add a new field that's the true date field. After the append, do a REPLACE realdate WITH CTOD(chardate)....this seems to respect the CENTURY settings.
>
>
>
>
>>Yes -- here is my syntax:
>>
>>SET CENTURY ON
>>SET CENTURY TO 19 ROLLOVER 48 &&y2k compliance
>>
>>APPEND FROM (lcFilename) TYPE SDF
>>
>>I am looking into the rollover value -- maybe too big?
>>
>>Jill

PMFJI:

Yeah, that's we do on the 'problem' date fields in our multi-GB download imports every nite. Of course the easy ones are already coming in with 4-digit year formats, but there's always the ones coming from the lazy mainframe programmers that don't...

Rob
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform