>From my web page, several years ago: Correcting Dates that are 1900 Years Too Early You should clean up these problems before your database needs to have both 20th Century and 21st Century dates in it. If you suspect you have First Century dates, confirm your suspicions with commands like this:
SET MESSAGES ON SET ERROR MESSAGES ON SET DATE FORMAT 'MM/DD/YYYY' SELECT datecol FROM table WHERE datecol < '1/1/0100' If you find any, you can correct them with this command: UPDATE table SET datecol = (datecol + 693960) + WHERE datecol < '1/1/0100' That number -- 693,960 -- happens to be the number of days between a date in the First Century and the same date nineteen centuries later. If you want to check my math, use R:Base date arithmetic to help: SET VAR vDaysIn19Cents = (RDATE(1,1,1997) - RDATE(1,1,0097)) (Legend has it that the number 693960 was on a yellow sticky note at every technical support workstation at Microrim.) On 13 Aug 2004 at 8:40, William Owens wrote: > I have 2 questions. First..I took table from Dos To Windows with a > date field. All dates show ex: 01/01 00082 or 12/31/0083 IS THERE A > WAY TO ADD 1900 TO MAKE DATES READ 01/01/1982 AND 12/31/1983? ALL DATE > FIELDS SHOULD BE 19XX > > > Also in form designer I click on Variables and Variable Builder screen > appears. Under define expression name I key vplot type : integer When > I click ok or add I get Information icon says Add/Change Expression > First! I cannot seem to be able to create new variable? > > Thanks > > Bill
