Access Date Format problem

Results 1 to 2 of 2

Thread: Access Date Format problem

  1. #1
    Join Date
    Dec 1969

    Default Access Date Format problem

    Hello,<BR><BR>i am a beginner to asp have have hit a stumbling block when trying to query an access dbase. Keep getting type mismatch when querying the dbase by date, the date field is set to date/time short format (dd/mm/yy). Regardless of the format typed (01/01/01, 010101 etc) in from the form, i get the same error.<BR><BR>If the dbase is queried using Date() to get todays results, all is fine. But typed date input is not excepted.<BR><BR>Any suggestions would be appreciated<BR><BR>Pete

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Date Format problem

    Make sure you put # marks around the date value like this:<BR><BR>#01/01/01#

Posting Permissions

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