simple question on changing year to 4 char.

[Howard2002]

what is the syntax for changing a year field from two char to four char. i have the field defined as 4 char. but the data is 2 char. there is no 2000+ years

 

[darrellblackhawk]

set century on and year(date()) I guess, but your question is a little confusing

How did the data get in there in the first place?

Was this a table and application pre-Y2k nightmare?


Darrell
'We all must do the hard bits so when we get bit we know where to bite'

 

[Mike Gagnon]

Howard2002

Darrell has given the solution SET CENTURY ON should do it. Don't forget if you use private datasessions in your form, you will have to reset it in the load of the form.
BTW as far back as FPW2.6, FoxPro has always stored the full 4 digits (I cannot speak for versions prior). Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[danceman]

since the days of dBase II, the complete 4 digit year was stored. with the set century on, you may want to view the help file on ROLLOVER. Attitude is Everything