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


Reply via email to