Date query working incorrectly (Reports - Charts)

[davie1982]

Hiya.

I have this code in a chart on one of my reports in the SQL query as a criteria.

>=[forms]![frmdatestuff]![txtstartdate] And <=[forms]![frmdatestuff]![txtenddate]

For some reason, if i want the chart to display for example 14.12.11 > 16.12.11 I place 14/12/11 in the [txtstartdate] input box and 16/12/11 in the [txtenddate] box. The problem is that the chart starts from 15/12/11. This isn't what I want. I'm having to put 13/12/11 in [txtstartdate]. It's like it's not registering the "=" in ">=". However, the end date works fine. Can anyone tell me where i've gone wrong?

 

[davie1982]

It all failed, but I fixed it. The format I was using in the [txtstartdate] and [txtenddate] was dd/mm/yy. Changing this to dd/mm/yyyy solved my problem.

 

[Norie]

Well I've never seen that, but I suppose there is room for confusion?

Does 11 mean 2011 or 1911?