When querying a list with DateTime filter values in CAML, it does not use the time portion of the datetime paramater values, and the returned resultset is wrong. If you add IncludeTimeValue property with the value of “True” on the “Value” node of the CAML query like below:
<Value Type=”DateTime” IncludeTimeValue=”TRUE”><Today /></Value>
your CAML query works just fine