Open Report Filter Stopped Working

[ggs]

Hi I have upgraded to Access 2010 and have found a bit of a problem with the following. The Command Button filters according to a text box (text) and two text boxes (date) for start and finish dates
The text filters but the date has no effect at all
Yet in the report data tab - filter this is the result using the command btn
[date_inc] Between #1/09/2011# AND #25/09/2011#
And this is the result using on report built in filter selection "Dates Between"


[date_inc] Between #9/1/2011# And #9/25/2011#
just the US UK date format reversed which should not matter?

Private Sub cmdFilter_Click()
Dim strWhere
If Not IsNull(Me.cboBranch) Then
strWhere = strWhere & "[BranchName]='" & Me.cboBranch & "'"
End If
If Not IsNull(Me.txtStartDate) Then
strWhere = strWhere & IIf(strWhere = "", "", " AND ") & "[date_inc] Between #" & Me.txtStartDate & "# AND #" & Me.txtEndDate & "#"
End If
DoCmd.OpenReport "rptIncListing2", acViewPreview, , strWhere
End Sub

any suggestions please

[RuralGuy]

Maybe this link will help: http://allenbrowne.com/ser-36.html

[ggs]

So to eliminate one factor I changed my local settings to US mm/dd/yyyy
and what do you know my filter works. So this is my problem. Why did Access 2007 handle this? (does not matter I'm here now)

So to fix this, is the code to concatenate the date to SQL the fix. And where does that go.
What will this mean for a user
A: whose local setting is mm/dd/yyyy
B: whose local setting is dd/mm/yyyy
?
thanks

[RuralGuy]

Use the Calendar to select dates and then you are under control of the format.

[ggs]

yes my two unbound boxes were date format short Date so the date picker was there and used. I will accept this code did work for me but now in Access 2010 it no longer does.
I have now followed this
http://www.everythingaccess.com/tuto...o-a-Date-Range
it is an AllenBrowne code and hey it works
so it's solved for now

[RuralGuy]

That's great! Thanks for posting back with your success and solution.