LIKE clause with dates

Results 1 to 2 of 2

Thread: LIKE clause with dates

  1. #1
    Join Date
    Dec 1969

    Default LIKE clause with dates

    I am doing a keyword search for all the fields in my database. One happens to be a date. My where statement looks something like this:<BR><BR>where strField1 Like &#039;%" & KeyWord & "%&#039; or DATEfield like &#039;%" & KeyWord & "%&#039;<BR><BR>It will not pattern match the date field. When i enter in "2/24/02" i do not get any results. any ideas on how i can convert() or use syntax ("#", etc) for it to work?

  2. #2
    Join Date
    Dec 1969

    Default You can't use like with dates

    Try &#060; and &#062;, or BETWEEN.

Posting Permissions

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