In SQL server,I have date called vdate(datetime). In my asp page, I have another date ddate (format is mm/dd/yy). I want to retrieve, all the records where vdate = ddate but the problem is vdate has time attached to it. I always get BOF or EOF is true error.<BR>eg: vdate in SQl is 5/23/00 9:58:00 AM<BR>ddate in ASP is 5/23/00. <BR>query = "select vdate from visits where vdate = &#039" & ddate & "&#039"<BR>how do I get rid of the time from vdate in the query. should I use datepart and get just month,day and year?<BR><BR>Thanks