Help with code!!! Urgent!

Results 1 to 2 of 2

Thread: Help with code!!! Urgent!

  1. #1
    Join Date
    Dec 1969

    Default Help with code!!! Urgent!

    Hi,<BR><BR>I am trying to have the search page search within a limited field of data from the database.<BR><BR>This is my current code<BR> "select * from cust where sdate like &#039;%" & key & "%&#039; order by sdate desc", db, adOpenForwardOnly, adLockReadOnly, adCmdText.<BR><BR>What I wish to do is that I wish to limit the search for example to search bewteen specific date for instance between 03/10/01 to 03/28/01<BR><BR>How can I have the code above to perform such a search?<BR><BR>Please help!<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, Queries

    The link to the ASPFAQs is at the top right corner of most every page on this site, including this one.<BR><BR>Yes, this question is in the FAQs, in that category.<BR><BR>No, you can NOT use LIKE with datetime fields. <BR><BR>

Posting Permissions

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