Caml query not using the time part in datetime. If your are doing a caml query and you see that your time is being ignored in datetime try this:
<Value Type=”DateTime” IncludeTimeValue=”TRUE”><Today /></Value>
You have to use IncludeTimeValue=”TRUE”.
3 Comments
Comments RSS TrackBack Identifier URI
[…] can include time as well as date when using the [Today] function. This is described by this blog by ucsharp. In CAML when using the [Today] function you can use the “IncludeTimeValue” attribute […]
[…] My queries were going very wrong and I couldn’t figure out why, so I pasted them into the CAML query tool and tested it and noticed it didn’t matter what time I set in my query it was ignored. The CAML editor doesn’t have an option to include time values, so I could not tell what was needed to make it work. I found this blog post https://ucsharp.wordpress.com/2007/10/11/9/. […]
[…] ucsharp for publishing this. Like – Dislike Bookmark It Free wordpress […]