>>>I am having a problem making a program year 2000 compatible. I need to display dates in a textbox in mm-dd-yy format. I have been trying to use SET CENTURY OFF and SET CENTURY TO 19 ROLLOVER 60. Any time this command is in effect and I type 01-01-01, the textbox automatically displays 01-01-2001. I have tried tinkering with as many date related settings and properties as I can find, but with no success. This happens in browse windows also. What I am I doing wrong?
>>Nothing. Try typeing in 01-01-61. It should show 01-01-1961. Any year after 60 is considered to be a 1900 year and any year before 60 is considered to be a 2000 year.
>
>Internally, SET CENTURY TO is exactly what I need, but I can't control the display of dates.
>If I type 01-01-61, it displays 01-01-61. If I type 01-01-01, it displays 01-01-2001 and I only want it to display 01-01-01.
Guess I should have 'read the problem' a little more carefully. One way to get the display you want is to set the ControlSource to a dummy variable say "xdate"(character string with a datetype input mask - ##/##/##.Then put :
testdate=ctod(substr(xdate,1,2)+'/'+ substr(xdate,4,2)+ ;
'/'+ substr(xdate,5,2))
in your valid event(where testdate is your real data item. There is probably a better way but this works.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only