And, if there are dates in your database that were stored 2000 years too early, you can do this:
UPDATE tablewithdate + SET datecolumn = (ADDYR(datecolumn,2000)) + WHERE datecolumn < '01/01/0100' Bill On Fri, Sep 17, 2010 at 3:04 PM, Bill Downall < [email protected]> wrote: > 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 >> >> >> >
