Amazing how many ways there are to skin a cat! David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 13, 2004 9:27 AM 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. > >
