Another clever solution! David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Walker, Buddy" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 13, 2004 9:15 AM Subject: [RBG7-L] - RE: dos to windows
Bill Try this UPDATE tablename SET datecolumn = (ADDYR(datecolumn,1900)) WHE (IYR(datecolumn)) < 1900 Buddy -----Original Message----- From: William Owens [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 8:41 AM To: RBG7-L Mailing List Subject: [RBG7-L] - dos to windows 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
