All i'm trying to do is retrieve records from the database which match a certain date, but for some reason i keep getting a 'type mismatch' error. I've writen it simply like this to show the syntax i have used.

VB Code:
  1. temp = "6/12/2006"

  2. GetData ("SELECT * FROM tblcosts WHERE start_date = '" & CDate(temp) & "'")

Could someone please to me what i'm doing wrong? I suspect its something stupidly simple. I've tried it with and without using 'cdate'

Cheers