query error: datatype mismatch

Results 1 to 2 of 2

Thread: query error: datatype mismatch

  1. #1
    Collins Guest

    Default query error: datatype mismatch

    Hi all,<BR>I have a database that has a field called Dates. Data on this field is of the date/time type. I&#039m using the Access database.<BR><BR>I also have an html(dates.htm) page and an asp (dates.asp)page<BR><BR>dates.htm has a form and two textboxes, the user has to submit two dates using this html page. I want to use the dates entered by the user in my sql query(dates.asp page). Problem is the user enters these dates as text, but the Dates field in the database is of type date/time as I have already indicated. That means whenever I try to run the query on my dates.asp I get a datatype mismatch error because the dates entered by the user are of type text where as they should be of date/time type. <BR><BR>How can I solve his problem.<BR>thanking you,<BR><BR>collins@nac.ac.za

  2. #2
    Join Date
    Dec 1969

    Default RE: query error: datatype mismatch

    if the field type is date/time, it would throw an error if a non-date value was entered. i think you have to look elsewhere for the problem.<BR><BR>show some code<BR><BR>j

Posting Permissions

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