× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Y2K and six digit date display
  • From: Glenn Ericson <Glenn-Ericson@xxxxxxx>
  • Date: Thu, 17 Dec 1998 00:35:24 -0500

James 
technique and  dates by meaning-  sounds fine  with a  phase II after 2000
worries.

I think I misssed something here.
What are all the  conversions from  6 to 8 to Gregorian to Juilian and back
about? How  does that add to the value of the compare etc.? 
Seems  like a lot of work for<??> gain/validation.   I know standard date
routines/APIs  but here are always those machine cycles.

Glenn
At 07:23 PM 12/16/98 -0800, you wrote:
>Glenn,
>
>I hear you,  when we first started on this issue the question came up as
to date
>data entry and my question was, for how long do you want users keying in
an entry
>two digits? (19xx or 20xx)  For some shops that adds up to a LOT of
keystrokes!
>
>What it boiled down to was as long as the underlying file was able to keep
dates
>properly we would leave the display/print alone.  Otherwise we would be
>revisiting the whole display/print issue is a couple of years when century
>turnover no longer became an issue.   Talk about job security ;-)
>
>We sat down and looked at the purpose of certain dates.  Birth date ...
>definitely 8 digits.  Hire date .... ditto, Invoice date, well a window
technique
>was good enough.  (BTW we store dates since 1991 as 7,0P  as cyymmdd ...
before
>ILE date data types)  Due date ... can't be before invoice date.  So for
>display/print purposes it depended on the nature of the date.  Since we
stored
>all dates as 7,0P we could add 1900 to the cyy and show 8 digit dates where
>appropriate (export to PC via query, etc.) but to fill the standard 80/20
rule
>... 80% of the time a 6 digit display/print was just fine.
>
>Where we changed our date validation routines is that we no longer looked
at year
>00 being invalid/ommitted.  Using a window technique we would take a 6 digit
>entered date, convert it to 8 digits, convert that to julian, convert the
julian
>back to gregorian and if the result matched the entered date it was valid.
 Then
>we might look for appropriateness, like could someone issue us an invoice
dated
>beyond today's date? Could an entry be made dated outside of a 120 day
window?
>(Auditor time frame ... or stops erroneous omissions until Sept. 1999)
Could an
>entry be made to a closed accounting period? Etc.
>
>Then there are the 20% cases where an 8 digit display/print date may very
well be
>appropriate, if for no other reason then to give a warm and fuzzy feeling
until
>enough years go by that it just takes up too much landscape.  Then the job
>security issues appears again ;-)
>
>James W. Kilgore
>email@James-W-Kilgore.com
>
>Glenn Ericson wrote:
>
>> <<snip<
>>
>> I know  a lot of words to tell you that  8 digits  is NOT  always the  best
>> solution, NOT always accepted easily, nor implemented  without infringing
>> on real estate  changes.
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
>
Seasons Greetings

Glenn
___________________________________________________
Glenn Ericson,          Phoenix Consulting                      
P O Box 701164   East Elmhurst NY 11370-3164 USA                            
Phone 718 898 9805       Fax 718 446 1150
AS/400 & Year 2000- - Solutions Specialists
 ©  copyright 1998,  all rights reserved
____________________________________________________


 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.