Search by Date Range

Results 1 to 2 of 2

Thread: Search by Date Range

  1. #1
    Dick Boarman Guest

    Default Search by Date Range

    I have a field in my database that contains a date that the record was created. How can I then create a search that displays only the records created between 2 dates that are submitted in a form. Example: Find all records created between 10/2/2000 and 10/15/2000. <BR>thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Search by Date Range

    strSQL = "select * " & _<BR>"from myTable " & _<BR>"where date_added between #10/2/2000# and #10/15/2000#"<BR><BR>Substitute &#039 for # if the database is not Access.<BR><BR>Hope it helps.

Posting Permissions

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