I can&#039;t figure out what&#039;s going wrong here. I&#039;m using a SQL 2000 db with the following query (MemberDate is a datetime variable)<BR><BR>Query="SELECT * From Memberlist Where MemberDate=&#039;"&date&"&#039;"<BR><BR>Sometimes this works, and othetimes it will give the following error:<BR><BR>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.<BR><BR>Any ideas about what&#039;s going on here? Thanks.