Date

[idowu100]

If Not IsNull(Me![IncidentEndDate]) Then
where = where & " AND [Incident Date] between #" + _
Me![IncidentStartDate] + "# AND #" & Me![IncidentEndDate] & "#"
Else
where = where & " AND [Incident Date] >= #" + Me![IncidentStartDate] _
+ " #"

I have typed the following code in a report but I am having problem displaying only the dates that I specifically asked for. It seems to be picking up other dates. Is there something wrong with this syntax?

Many thanks.

 

[Rich]

You have to use the US date format in strings
& Format(Me![IncidentEndDate],mm/dd/yyyy)