>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
Here you can do an UPDATE table SET date = 2000 where date = 1900
or some permutation of that idea. But that doesn't cure say for example 1932 so you would have to be a little more creative than that.
>2. Code in my pre-processing routine to prevent this from happening..
If your preprocessing routine is written in VFP you have a number of options. One being SET CENTURY w ROLLOVER clause and implementing a strict date format would be another (see Help on Strict Date). There is also a compiler option in the Tools / Options screen to check for problems in your code regarding dates.
HTH
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California