Re: Year 2000...

In article <32FA9A83.18AB@gte.net> dgwilson@gte.net writes: >> Jonathan Leffler wrote: > >> } I regard the second option as the more likely. The only sensible fix is to >> } change your programs to display all 4 digits of the year. This has been >> } true since before I4GL was introduced to the market, and will remain true >> } into the indefinite future. >> } > >A less sensible and more of a hack fix, if you absolutely positively >want or need to only display 2 digits, would be to add an "after field" >block after every date entry and if its less than some reasonable >amount then change it from 19xx to 20xx. That would be if its for >something like order or invoice dates which would be recent. If I *had* to do this, I'd use SPL called from a trigger on the affected table. Then you'd be at least guaranteed of consistent handling in all cases. But I don't. Everything I've ever written has 4 digit years. I saw this coming when I *started* programming, nearly 20 years ago. (In fact, I use dd-mmm-yyyy format to save arguments/ambiguity w.r.t. American and *real world* :-) date formats/displays). Gloat :-) Peter Wiley