Howard: check your date setting by typing SHOW DATE. You probably want: SET DATE SEQ MMDDYY so that if you type only 2 digits for the year it will assume the century 2000. Also check your "set century" and "set year" settings.
Karen > 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
