Re: How "BETWEEN date1 AND date2" determines century

A piece of software I use holds a "SYSTEM KEY" called CENTURYEAR. This variable holds a value between 0 and 99 All 2-digit years handled by the system that are less than CENTURYEAR are considered to be in the /last/ century, those greater than or equal to CENTRYEAR are in this one. Simple and neat I thought. ------------------------------------------------------------------- These are *my* opinions. Please don't make the mistake of believing anybody else is stupid enough to think like this! ------------------------------------------------------------------- Stuart Hemming | shemminga@cix.compulink.co.uk The Data Base | Tel: + 44 (0) 115 925 0005 Nottingham UK | Fax: + 44 (0) 115 925 0951 -------------------------------------------------------------------