Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: problems with RRRR format

Re: problems with RRRR format

From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: 1998/11/10
Message-ID: <3648124b.601361982@news.brookes.ac.uk>#1/1

On Tue, 10 Nov 1998 02:20:54 GMT, ravipadma_at_aol.com wrote:

>We are planning to use RRRR format at the form level for Y2K compliance. Did
>any of you experience problems with this format. Thanks a lot in advance.
>Ravi.

  1. We've never used it, but I think it's RR, not RRRR.
  2. The reason we've never used it is that we have to deal with dates before 1950. RR turns 50-99 into 1950-1999, and 00-49 into 2000-2049.

It's not truly compliant (IMO) unless you can enter (for example) both 1949 and 2049. This means 4 digit year fields.

--
Tommy Wareing
MIS Group
Learning Resources
Oxford Brookes University
01865 483389
Received on Tue Nov 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US