> I'm trying to permit entry of a full date in mm/dd/yyyy format using a VFP form. In my procedure I have included the following statements: SET DATE AMERICAN, SET CENTURY ON. Browsing the database shows the full date in mm/dd/yyyy format. However, I can only enter a 2-digit year in the form. Also, I'd like to have this date changed to the system date automatically whenever a record is updated. I'm using VFP v6.0, Svc Pack 4. Can anyone help?

George,

Set the DATEFORMAT property of your textbox to American. In the InputMask, enter "99/99/9999". Initialize (in the INIT method) the type of the textbox to Date by entering This.Value = DATE().

Bebot