dbTalk Databases Forums  

Two Digit Year Threshold

comp.databases.pick comp.databases.pick


Discuss Two Digit Year Threshold in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
frosty
 
Posts: n/a

Default Two Digit Year Threshold - 03-05-2007 , 01:13 PM






on UniData 6.1:

FOR I = 8 TO 99 WHILE ICONV('1/1/':I,'D') > DATE()
Y = I
NEXT I
CRT OCONV(ICONV('1/1/':Y,'D'),'D4/')
CRT OCONV(ICONV('1/1/':Y+1,'D'),'D4/')

01/01/2029
01/01/1930

So any two- (or one-) digit year from 08 (8) to 29
is assumed to be in the future.

Questions: Does this threshold increment over time?
Is there a UDT.OPTIONS for this? Does the threshold
change from o/s to o/s? Will I be around to type
'4/2/56' and get '04/02/2056' ?!?

--
frosty



Reply With Quote
  #2  
Old   
Martin Phillips
 
Posts: n/a

Default Re: Two Digit Year Threshold - 03-05-2007 , 01:23 PM






There is an item in the Unidata configuration parameters to move the
start of the 100 year period covered by two digit year numbers.

UniVerse and QM do much the same. Other systems also hopefully have
something similar.


Martin Phillips, Ladybridge Systems


Reply With Quote
  #3  
Old   
Scott Ballinger
 
Posts: n/a

Default Re: Two Digit Year Threshold - 03-05-2007 , 01:42 PM



On Mar 5, 11:23 am, "Martin Phillips" <MartinPhill... (AT) ladybridge (DOT) com>
wrote:
Quote:
There is an item in the Unidata configuration parameters to move the
start of the 100 year period covered by two digit year numbers.

UniVerse and QM do much the same. Other systems also hopefully have
something similar.

Martin Phillips, Ladybridge Systems
In UV this is the CENTURYPIVOT parameter in UVCONFIG, but I don't
think this is configurable in D3.
On 7.4.2 and 7.5 it seems to be 30, i.e. 1-1-29 = 2029, 1-1-30 = 1930.
Hopefully it floats, so that next year it will be 31, etc.

/Scott



Reply With Quote
  #4  
Old   
Joe
 
Posts: n/a

Default Re: Two Digit Year Threshold - 03-05-2007 , 01:48 PM



"Scott Ballinger" <scott.ballinger (AT) gmail (DOT) com> wrote in
news:1173123743.932634.86500 (AT) s48g2000cws (DOT) googlegroups.com:

Quote:
On Mar 5, 11:23 am, "Martin Phillips" <MartinPhill... (AT) ladybridge (DOT) com
wrote:
There is an item in the Unidata configuration parameters to move the
start of the 100 year period covered by two digit year numbers.

UniVerse and QM do much the same. Other systems also hopefully have
something similar.

Martin Phillips, Ladybridge Systems

In UV this is the CENTURYPIVOT parameter in UVCONFIG, but I don't
think this is configurable in D3.
On 7.4.2 and 7.5 it seems to be 30, i.e. 1-1-29 = 2029, 1-1-30 = 1930.
Hopefully it floats, so that next year it will be 31, etc.

/Scott
IIRC it doesn't float in "generic" pick (or whatever it's called these
days). Maybe one day we'll see it on Letterman. <rim shot>

Regards,
Joe


Reply With Quote
  #5  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: Two Digit Year Threshold - 03-05-2007 , 09:10 PM



"Scott Ballinger" wrote:

Quote:
I don't think this is configurable in D3.
On 7.4.2 and 7.5 it seems to be 30, i.e. 1-1-29 = 2029, 1-1-30 = 1930.
Hopefully it floats, so that next year it will be 31, etc.
'set-date-window' is not in the D3 v7.5 Ref but I believe this command
has been available for a couple years now.

T


Reply With Quote
  #6  
Old   
Mark Brown
 
Posts: n/a

Default Re: Two Digit Year Threshold - 03-06-2007 , 02:41 AM



T Man,

Thanks for remembering. I wrote this back in '99 as part of the Y2K effort.

set-date-window ? has some help.


Mark


"Tony Gravagno" <address.is.in.posts (AT) removethis (DOT) com.invalid> wrote in
message news:7nmpu2hml1jt2sh14bhtklecemg0sfou3p (AT) 4ax (DOT) com...
Quote:
"Scott Ballinger" wrote:

I don't think this is configurable in D3.
On 7.4.2 and 7.5 it seems to be 30, i.e. 1-1-29 = 2029, 1-1-30 = 1930.
Hopefully it floats, so that next year it will be 31, etc.

'set-date-window' is not in the D3 v7.5 Ref but I believe this command
has been available for a couple years now.

T



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.