Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: George Mortimer
  Where is George Mortimer?
 Chalfont
 Pennsylvania - United States
 George Mortimer
 To: Bebot Chan
  Where is Bebot Chan?
 Riyadh
 Saudi Arabia
 Bebot Chan
 Tags
Subject: RE: Date entry problem.
Thread ID: 22955 Message ID: 22968 # Views: 21 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Wednesday, April 30, 2003 9:10:53 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?
>
> 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

Bedot,

I was able to get the century part of the date to work now. I had to go into Properties, Text Box Builder of the date field, then check off "Enable at run time" and "Select on entry". (The latter box had not been checked.) The INIT process does not work, but I'll try working on that some more. I've programmed in other languages, but FoxPro is new to me. I really appreciate your help!

COMPLETE THREAD

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