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...