Re: L-date fields

[Bob Angell <aimsllc@xxxxxxx>]

Neil Palmer wrote:
> 
> boothm@earth.goddard.edu wrote:
> >

> would be 04 June 1997.  However when you see 1997-04-06 is there any
> doubt that this is April 4th 1997 ?
> As we move towards a global economy, isn't it about time we all started
> writing dates the same way ?  I say give the users yyyy-mm-dd and don't
> take any crap from them !

AMEN!!!  I have been designing DB systems with this strategy for years.
They bitch and moan (b&m) initially but when it comes down to entering
data (or making sure the dates are correct, especially in some of my
medical applications where I must USE the previous century for the
DOB when it is automated) it provides good data integrity.  I BELIEVE!!
<G>

-Bob-
-- 
   Bob Angell, Principal - Sys. Engineer/Author/Consultant
   Applied Info & Mgnt Sys, 1238 Fenway Ave., SLC, UT 84102 
   v: 801-583-8544 e: aimsllc@ibm.net / bangell@cs.utah.edu
   --------------------------------------------------------
   --------------------------------------------------------
   "Had Mama Cass and Karen Carpenter shared that Ham sand-
   wich, they would both be with us today!"
+---
| 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
+---