1.
UPDATE <table> +
SET <datecolumn> = (ADDYR(<datecolumn>,1900)) +
WHERE <datecolumn> < 01/01/1900
2. The OK button is to close the designer - look for the Add/Change button to the left of the OK button.
William Owens <[EMAIL PROTECTED]> 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
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
