I knew you'd kick in here Bill! David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 13, 2004 9:19 AM Subject: [RBG7-L] - Re: dos to windows
> >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 > >
