Problems with Date Search

Results 1 to 2 of 2

Thread: Problems with Date Search

  1. #1
    S Hatchard Guest

    Default Problems with Date Search

    Hi<BR><BR>Please help - I am trying to pull a record from the Access Database based on its date and the UserID. The date comes in on the querystring and i use CDate to format it. Whenever I search though i get...<BR><BR>[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. <BR><BR>/mydiabetes/mainhome.asp, line 67 <BR><BR>I have tried everything I can think of - changing the format in Access, not using CDate etc etc but to no avail.<BR><BR>Thanks in advance for any help - this is driving me round the bend!

  2. #2
    SPG Guest

    Default RE: Problems with Date Search

    Without looking at the code, I have to ask... does it look kind of like <BR><BR>... where dateField &#062;= #" & cDate(request.queryString("usrDate")) & "# ... ?<BR><BR>Access uses the # signs to note that an incoming date is a date (as opposed to a really ugly integer or something). My current guess would be that you left them out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts