|
In article <3.0.16.19970914101154.094f1d52@Postoffice.att.net>, Glenn Ericson <Glenn-Ericson@att.net> writes >Two digit years with windowing[ sliding] could work in some cases as >long as the user understands it ...and there is time to do the programming >effort. (see below) > >At 03:56 PM 9/13/97 +0000, you wrote: >>Wouldn't a d-o-b field be considered "strictly necessary" for a 4-digit >>year on the screen? as well as any fields relating to property deeds and >>transfers, historical references, obvious on-screen sorting fields and >>filters, and query usage? It's reasonable to expect a user to understand >>the appearance of 4-digit years in those cases. While most dates will >>easily be contained in the 100-year window we now have available, if there >>is any doubt about a field then it should have 4-digit displays on the >>screen. >> >>on 09/13/97 at 07:29 AM, "Kahn, David" <KAHN@tengizchevroil.com> said: >> >>A program should not accept a future DOB under any circumstances. The >>program should be able to calculate the reasonable window for any >>particular date and force confirmation of the defaulted century whenever >>there is more than one possible solution. I don't think it's reasonable >>to expect users to key the century part of the date when it's not >>strictly necessary. >> >>Dave Kahn >Booth >It is possible to have 2 digits on the screen or report and 4 in the >database. Here you window the input/output with some sort of intelligent >date routines. > My company specialises in Payroll and Personnel systems and we initially planned that all dates would be stored and displayed in DD/MM/YYYY format but after looking further we have changed our minds. We still intend to hold all dates as the full 8 digits on the files but only dates such as date of birth/retirement will request the user to enter all 8 digits. Other dates will be input/displayed as six digit dates and we will use windowing to determine the century before writing the data back to the file. By the way, this problem has been with us for a number of years now; as an example we have a client who has an employee on the pensioners payroll who was born in 1898 and retired in 1963. To get round this problem we had to get them to enter the year as 00. -- Fred Mitchell fred@mitchf.demon.co.uk Newcastle upon Tyne, England http://www.mitchf.demon.co.uk +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MAJORDOMO@midrange.com | and specify 'unsubscribe MIDRANGE-L' in the body of your message. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
