Clever Geek Handbook

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.

+1


source to share


3 answers


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>
+5


source


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.

0


source


does this work with ssrs 2005 ??

            2008-12-03T12: 00: 00Z

0


source






More articles:


All Articles