Trim Format DateTime in Just Date Format in CAML Request
I am trying to create a CAML query for a SharePoint 2007 environment to get items from a calendar list. Want to query items with data "From date" and "To date", the calendar list contains "EventDate" and "EndDate" in Datetime format. I'm only interested in the date date of the datetime field.
How can I trim the DateTime "EventDate" field in the Calendar list to just be "Date" and compare?
Is there any other way to do this other than CAML.
Unfortunately, you have to use CAML.
You will be able to trim the time portion ...
<Where>
<Gt>
<FieldRef Name='EventDate' />
<Value IncludeTimeValue='FALSE' Type='DateTime'>2008-12-03T12:00:00Z</Value>
</Gt>
</Where>
Conversely, if you are working with the object model in code, you can use LINQ to SharePoint ( http://www.codeplex.com/LINQtoSharePoint ).
In the background, the project just creates a CAML request for you, but you don't need to use the CAML directly.
does this work with ssrs 2005 ??
2008-12-03T12: 00: 00Z