I am using :<BR>SELECT * FROM [TableName] WHERE ResponseDueDate &#062;#2/28/2000# And ResponseDueDate&#060;#3/16/2000# <BR><BR>The problem is :<BR>when the year is 1999 or less it shows 99...thus 4/11/1999 is 4/11/99 and 4/11/2000 is 4/11/00 which mucks up the world! Y2K! The temp solution was to create extra field adding 19 years to the date. <BR><BR>The question is :<BR>How can I make it see the date in the select statement as 1999 and 2000 instead of 99 and 00?<BR><BR><BR><BR>