Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing Data In a Grid Cell

Status
Not open for further replies.

Stagmotor

Programmer
Dec 8, 2000
10
US
In vfp 5 one column in a grid displays the dates as:

20000831
20010901
20000902 etc

I want to manipulate it to show those dates as:

08/31/2000
09/01/2001 etc I tried a prg in different methods of the column etc... Nothing works, how do I do it ?
Thanks!!
 
Hi,
I understand, you are having the data as a text field.
If that is the case you can do the following
In that Columns.Text1.InputMask PUT THE VALUE ...
9999/99/99
This will mimik that format. But remember the date field need to be checked fo validation, if data need to be accepted.

If the field is date field, you can look at some cotradictory display format you might have used.

Hope this helps
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top