Changing the year in a date field

[blumash]

Latly I changed a date field by putting 'SET CENTURY ON', the year in this field changed from 04 to 1904 instead of 2004 , how can I change the year in the field to be 2004 ???

Thank's

 

[JRB-Bldr]

Is the 1904 value coming from values previously stored in a data table or is it a value that you are setting into a memory variable and then displaying on screen?

If it is coming from previously stored data table field values, USE the table and change the DATE field values as necessary.
Something like the following should move all date values up 100 years..

USE MyTable IN 0
SELECT MyTable
REPLACE ALL DATEFLD WITH GOMONTH(DATEFLD, 12*100) FOR YEAR(DATEFLD) < 1990  && Randomly picked 1990 year

Values stored from this point forward (after the SET CENTURY ON was added) should have the proper year.

If it is coming from a value you set as a Default Value, change your default by specifying the appropriate year.

Good Luck,
JRB-Bldr

 

[dbMark]

The reason you see "1904" when the date field was expanded is that the older FoxPro programs defaulted the century to the 1900s. It did not know to pick up the correct century when the short 2-digit form was typed into any entry screen. That's why some sort of code is needed to handle that issue.

dbMark

 

[rgbean]

Just remember that it isn't "guessing" that 04 is 1904, that's what's actually stored in the data table. It was pretty critical that as of 2000 that ALL data fields in FPD and FPW allowed four digits for the year and SET CENTURY was ON. The only alternatives were to use a third party product like Y2KFOX - at

http://www.y2kfox.com/legy2ksof.html.

Or get the code that was published in 1998/1999 in FoxPro Advisor Magazine and fix it yourself. I believe it's available on their website

http://foxproadvisor.com/.

(Do a Search on Y2K - unfortunately to read the good articles and get the code, you'll need to subscribe!)

Rick

 

[blumash]

Thank u all for your help , I solved the problem.