CAML & DateTime

Whenever querying anything with Date and Time as one of the field under <where\> condition

  • They should be converted to ‘ISO8601’ format i.e yyyy-mm-ddThh:mm:ss.. this can be done by calling
  • By default CAML only takes the date as parameter and ignores the Time. To have Time also as a condition it requires
    IncludeTimeValue=’TRUE’as parameter
    for e.g
    <FieldRef Name=’Created’ /><Value Type=’DateTime’ IncludeTimeValue=’TRUE’/>
  • To have the current date use : <Today />
  • One of the most common question when using CAML is , “is it possible to do something like: get last 5 days data ? “
  • Or in another words would it be possible to introduce something like Today – 5 (days ?)
    Big Answer after lots of search is YES
    If you want to work with the date of today, you could use the syntax <Today /> and if you want to do simple calculations i.e. adding or subtracting a certain number of days of today’s date you could make use of the syntax <Today OffsetDays=”5″ />.

    In a content query web part you could integrate a query like the following:
    <FieldRef Name=”StartDate”/>
    <Value Type=”DateTime”><Today OffsetDays=5 /></Value>
    In case of more complex calculations on dates, you could make use of SPUtility.CreateISO8601DateTimeFromSystemDateTime in combination with the different calculation methods on the DateTime data type.

    I have seen that some guys uses [Toda-2Day(s)] format to add/substract no if days from date, but it never worked for me.

  • 1 Comment

    1. May 7, 2008 at 10:21 AM

      […] CAML & DateTime […]

    Leave a Reply

    Fill in your details below or click an icon to log in: Logo

    You are commenting using your account. Log Out /  Change )

    Google photo

    You are commenting using your Google account. Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s

    %d bloggers like this: