That works for me... Thanks again. Bill
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Friday, August 13, 2004 9:27 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: dos to windows At 08:40 AM 8/13/2004 -0400, Bill 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 Bill, Here's is one way of taking care of that: Assuming that the database DATE FORMAT, SEQUENCE, YEAR and CENTURY settings are as follows: DATE FORMAT MM/DD/YYYY DATE SEQUENCE MMDDYY Century threshold YEAR 30 Default CENTURY 19 Then, to update all 01/01/0082 and 12/31/0083 to 01/01/1982 and 12/31/1983, use the ADDYR function of R:BASE. Here's how: 01. Make a backup copy of your database 02. Start RBG7 03. CONNECT dbname 04. At the R> Prompt: UPDATE tablename SET datecolname = (ADDYR(datecolname,1900)) + WHERE (IYR(datecolname)) = 82 OR (IYR(datecolname)) = 83 >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? If you have selected to define an Expression, you have to define the expression before clicking on any buttons accordingly. If you are simply defining a Global Variable while still in Variable Builder, you'll need to click on "Global". Hope that helps! Very Best R:egards, Razzak.
