Re: How "BETWEEN date1 AND date2" determines century

> > All this talk about dates!!! I am very concerned. Many of the data entry > screens developed in the past only allow room for an 8 character date > string. This is often on very busy screens. Please do not forget this > or leave it until year 1999. > > I would suggest that any organisation running any software would be well > advised to check their data handling abilities as soon as possible. > Recently I was doing some code rework for a major UK company. They had > set a century flag in their "homebrew" date format. The existing code > would well if it was the 20th century, but didn't work for the 21st. And > that same code had been propagated throughout 100s of aplications. > Don't worry so much, Leap year does not occur every 100 years, but DOES occur every 400. So 2000 IS a leap year. Yes, you have to worry about "19" + YY, but not about all the leap year bs. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Back up my hard drive? You mean these things can actually run in reverse? _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________