Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing 1900 to 2000
Message
From
27/07/2001 18:13:45
Erik Moore
EKraft
Austin, Texas, United States
 
 
To
27/07/2001 16:12:13
Jeffrey Turner
Independent Contractor
Various Locations, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Changing 1900 to 2000
Miscellaneous
Thread ID:
00536667
Message ID:
00536721
Views:
9
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
Previous
Reply
Map
View

Click here to load this message in the networking platform