Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Web Development
  3. SharePoint
  4. CAML Query is not working [modified]

CAML Query is not working [modified]

Scheduled Pinned Locked Moved SharePoint
database
3 Posts 2 Posters 9 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    pavan garlapati
    wrote on last edited by
    #1

    Hi My requirement is Get all the items in the list with Current System date. The list has a column name "Created" type is "DateTime". I write a CAML query like following Today_Date = System.DateTime.Now.Date.ToString("yyyy-MM-dd"); SPQuery qry = new SPQuery();

    qry.Query = "<pre>Query Where Eq </pre>";
    qry.Query += "<pre> FieldRef Name=\"Created\" </pre>";
    qry.Query += "<pre> Value IncludeTimeValue='FALSE' Type=\"DateTime\";
    qry.Query += <pre>Today_Date + "Value";<pre>

    modified on Thursday, March 18, 2010 12:40 AM

    N 1 Reply Last reply
    0
    • P pavan garlapati

      Hi My requirement is Get all the items in the list with Current System date. The list has a column name "Created" type is "DateTime". I write a CAML query like following Today_Date = System.DateTime.Now.Date.ToString("yyyy-MM-dd"); SPQuery qry = new SPQuery();

      qry.Query = "<pre>Query Where Eq </pre>";
      qry.Query += "<pre> FieldRef Name=\"Created\" </pre>";
      qry.Query += "<pre> Value IncludeTimeValue='FALSE' Type=\"DateTime\";
      qry.Query += <pre>Today_Date + "Value";<pre>

      modified on Thursday, March 18, 2010 12:40 AM

      N Offline
      N Offline
      Not Active
      wrote on last edited by
      #2

      Please format the code using pre tags so all relevant code is visible


      I know the language. I've read a book. - _Madmatt

      P 1 Reply Last reply
      0
      • N Not Active

        Please format the code using pre tags so all relevant code is visible


        I know the language. I've read a book. - _Madmatt

        P Offline
        P Offline
        pavan garlapati
        wrote on last edited by
        #3

        I am not getting you....

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups