Hi Eric,
>Actually this issue is related in that I have numerous people who have used a >2 digit >year in their data entry and now they have a person who died in 16 and were >born in 28 which makes them -12 years old right? According the the 4D date >format that is right. >At least based on what I am seeing in 4D with the pivot dates that is right. >The >question is how to force people who are entering dates to put in a 4 digit >year, >and be able to find the 2 digit years and be able to correct them to a proper >4 digit year. >Without messing up properly entered 4 digit years. With birthdates I don't think there is any question that 4 digits are mandatory. Pivot years don't help. It's gotta be totally unambiguous. Tom Benedict Optum This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
