Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing 1900 to 2000
Message
De
27/07/2001 18:13:45
Erik Moore
EKraft
Austin, Texas, États-Unis
 
 
À
27/07/2001 16:12:13
Jeffrey Turner
Independent Contractor
Various Locations, Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Changing 1900 to 2000
Divers
Thread ID:
00536667
Message ID:
00536721
Vues:
8
This message has been marked as a message which has helped to the initial question of the thread.
>I have some records in my system from our mainframe that have the year as 1900. Does anyone know of a simple way I can:
>
>1. Change the year to 2000
>2. Code in my pre-processing routine to prevent this from happening..

REPLACE MyDate WITH GOMONTH(MyDate, 12 * 100) FOR MyDate < SomeDateInTheEarly1900s
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform