Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    90

    Unanswered: Query between 2 dates

    I am having some trouble getting a query to work that finds all the records that are between a certain date range.

    I have a form where the user inputs the dates that they want to look between. Then I use this code

    WHERE Seminar.Date BETWEEN StartDate AND EndDate

    where StartDate is a value from a form in the form mm/dd/yyyy
    and EndDate is a value from a form in the form mm/dd/yyyy
    I have also tried putting StartDate and EndDate in the form mm-dd-yyyy
    but it did not work.

    The problem is that all my Seminar dates are stored in the form
    (m)m/(d)d/yyyy where if a month or day is 01 it is stored 1 etc...

    Anyone know how I can do this?

  2. #2
    Join Date
    May 2004
    Posts
    90
    Nevermind, I got it. Just put # signs before and after the date.

Posting Permissions

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