Howard, You have your DATE SEQUENCE setting wrong. It should be set to two Ys, not 4. When it is four, you are requiring that on data input, all four digits of the year must be entered.
Here is what you should have: R>sho date DATE format MM/DD/YYYY DATE sequence MMDDYY Century threshold YEAR is 30 Default CENTURY is 19 Bill On Fri, Sep 17, 2010 at 2:58 PM, Howard Langfus <[email protected]>wrote: > Hello list. I am using the latest version of 9(32). Settings include > century = 19 and year = 30. Having a problem filling in the correct year on > all forms created under 7.6. If I create a new date field under v9 it fills > in properly. Typing show var at the R> lists dates correctly. > > At present <enter>ing a date such as 9/17/10 on a form yields 9/17/0010, > not the expected 9/17/2010. > > A possible solution I came up with is to: > 1. Create new date columns, > 2. Copy the date record information from the old columns to the new ones, > 3. Rename the original columns, and > 4. Rename the new columns back to the original column names. > > Now for my 2 part question. 1-Is there a better way to accomplish this? > 2-How to “copy” the data in each record to the new columns? What steps are > required to update the rows in the new columns? > > TIA for you help. > Howard > > >
