Queries :: Access 2013 - Filtering Report By Date?

Access version: 2013 / The user can click a button on the report that opens a form where they can select various filters. Once the user has selected the filters and clicks done, I have some VB code that fires which builds an SQL string with all of the filters selected. It then reopens the report with the new filter.

What I am running into issues with is one specific filter that the user can select. They can select a "from date" and "to date". Sometimes this filter returns what I want and sometimes it doesn't.

For example. I set 01/01/14 as the start date and end date as 15/01/14. <-- this works as desired.But if I put start date as 10/12/13 and end date 15/01/14 for example then it returns all previous records up to the specified end date. I.E dates such as 10/10/13 will show.

This is the VB code used to build the SQL for this filter:

Code:

newWhere = newWhere & "[FollowUpDate] > #" & Me.txtFromDateSelect & "# AND [FollowUpDate] < #" & Me.txtToDateSelect & "#" & " AND "

note: I have also tried using the between SQL syntax for querying the date to no avail and the same results.

This is the SQL that the above code creates:

Code:

[FollowUpDate] > #1/01/2014# AND [FollowUpDate] < #15/01/2014#

This only happens when I try select a start date prior to 12/12/13 (so the year is not the issue)

This happens both when I apply just the from date and to date filter and also when I mix it in with other filters. I.E Company name, product etc..