Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Blum
  Where is Ken Blum?
 Illinois - United States
 Ken Blum
 To: George Mortimer
  Where is George Mortimer?
 Pennsylvania - United States
 George Mortimer
Subject: RE: Date entry problem.
Thread ID: 22955 Message ID: 22962 # Views: 6 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Wednesday, April 30, 2003 6:10:51 PM         

> 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?

Your Form is probably set to a Private Data Session...

On the Load Event of the form, try setting SET CENTURY ON

From Help: SET CENTURY is scoped to the current data session. New data sessions are initialized to the default values as specified above, ignoring the value of SET CENTURY for the current data session.

To have data chenged when a record is updated you would set the Update Trigger of the table in the database. See help under "Triggers".



Date entry problem. Posted by George Mortimer @ 4/30/2003 4:50:01 PM
RE: Date entry problem. Posted by Bebot Chan @ 4/30/2003 6:08:33 PM
RE: Date entry problem. Posted by George Mortimer @ 4/30/2003 9:10:53 PM
RE: Date entry problem. Posted by Ken Blum @ 4/30/2003 6:10:51 PM