Oops - I left off the WHERE clause
UPDATE datecolumn IN table SET datecolumn = (addyr(datecolumn,2000))
WHERE datecolumn < "01/01/2000"
to get the data the way it should be.
Albert
On 16/12/2010 2:00 PM, Albert Berry wrote:
I ran the Show Date command at the R> prompt in 7.6 for Windows.
in your list the terms are as shown. When issuing the SET DATE
commands in R:Base, you will need to use format and sequence, I think.
Output = Format
input = sequence
You should perhaps change the sequence to a 2 digit year and see if
that resolves the problem. If users input the date with only 2 digits,
in your database today would appear as 12/16/0010 instead of
12/16/2010. This can cause "interesting" troubles.
UPDATE datecolumn IN table SET datecolumn = (addyr(datecolumn,2000))
to get the data the way it should be.
Hope this helps point you in the right direction.
Albert
On 16/12/2010 9:25 AM, Jim Belisle wrote:
I just did an unload reload of the whole database with no errors being
reported. I tried the form again and got the same error.
My date settings are as such in 7.6:
Output mm/dd/yyyy
input mmddyyyy
Default century 19
Century threshold 30
I see no sequence string that you mentioned in the config settings.
When looking in the table as you mentioned, the nulls looked like nulls
to me.
James Belisle
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Albert
Berry
Sent: Thursday, December 16, 2010 10:12 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: DB grid
Jim - check your date settings in the database to ensure that you have
the date set properly. Note that the sequence has only a two digit year
in it. Here is an example. Note the sequence string.
R>show date
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 89
Default CENTURY is 19
On 16/12/2010 9:04 AM, Jim Belisle wrote:
Alastair,
I sorted all three date columns in that table, corrected anything that
looked remotely odd, and tried again.
I still get the same error. I also put a date format in the table
settings just to be safe and that made no difference.
This is a slave table.
