Dates in a Grid 1

[smcgayle]

I'm new to VFP and have created a form with a grid. My date format is set to century on and all text boxes on the form display with century. However, the dates in the grid are displaying as MM/DD/YY. I've tried to use the format for the column without success. How can I make the dates display as MM/DD/YYYY?

 

[DSummZZZ]

Did you issue a SET CENTURY ON statement in the LOAD event of the form itself? CENTURY may be getting set to off elsewhere without being immediately apparent.

Dave S.

 

[fluteplr]

Grid columns do not respect the set century setting. Only the text boxes do, so only if the row and column with the date has focus will the date display as you want. You can set the column property sparse to .f. to always display the data in the text box if you want.

 

[DSummZZZ]

What can I say. It worked on my grid.

Dave S.

 

[oaliev]

just told above the only way is

SET CENTURY ON