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.
