allow Null in the database, and save the value as a Null. Don't EVER save a valid date if no valid date exists, the practice will come back to haunt you.
i.e. One place I worked for used the date 31/12/99 as a 'dummy' date for 30 years, from the day the Government bought them computers in the early 1960s until they updated their systems in the early 1990s. They had a serious problem with the year 2000. Not with the expected problems, but with the 10s of thousands of records in their data base which suddenly ALL needed an hour of someone's time to review the persons continued eligibility for the Government payment they received. There being no way short of looking to establish if the date was a 'dummy' or legitimate. Matt ----- Original Message ----- From: "Arnold Marquez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 24, 2004 10:34 AM Subject: [vbhelp] Date Validation > > what is to best thing to do to avoid error when saving null values to a date field? > > > --------------------------------- > Do you Yahoo!? > New and Improved Yahoo! Mail - 100MB free storage! > > [Non-text portions of this message have been removed] > > > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
