James Overman <[log in to unmask]> after > David Greer ([log in to unmask]) wrote: > : <<big snip>> > : probably default the cut-off date to 50 (i.e., 500101 will be assumed > : to be January 1,2050, but January 1, 490101 will be interpreted as > : 1949). We have enough feedback from our customers to know that the > > Don't you want 490101 to be 2049 and 500101 to 1950?? Thus 000101 would be > 2000 !! This sounds a little like my former boss's "quick and dirty" fix. The whole "Year 2000" situation is much more serious than that. For example, you couldn't possibly use this method on a stored Birth Date field (just counted over 500 students-past and present- born prior to 1950, and then stopped counting...) So, you'd end up with different logic to "control" different types of date fields, and likely more errors within the data. Isn't it better and safer to convert the data to hold the century and be done with it? Yes, there's still a lot of work involved, but when it's done, it's done. You won't have the ugly date problem coming back to slap you in the face on a regular basis. Just my $.02 worth. Debbie ----------------------------------------------- Debbie Blumenthal, Computer Services Conestoga College, Kitchener, Ontario CANADA [log in to unmask] ----------------------------------------------- We have enough youth, how about a fountain of SMART?