One of my students pointed this out to me and I just tested it. In Access 2000 and 2002, if you set up a date/time field in table design, switch to datasheet view and enter a date such as 4/23/993, it accepts it as is. If you enter 4/23/003 it changes it to 4/23/2003. Any "year" 991, 992, etc. remains the same. This then messes up any pickoff criteria. Does anyone know why Access accepts such an invalid date? It can't think it's the year 987 because it changes 006 to 2006.
Thanks.
Thanks.