title: sort by date in caml query
body: <p>I want to sort my list items by date:</p>
  
  <p>I m using </p>
  
  <pre><code>&lt;OrderBy&gt;&lt;FieldRef Name='SortDate' Ascending='True'/&gt;&lt;/Order By&gt;
  </code></pre>
  
  <p>but its giving me results randomly.Is it possible to sort by date in CAML if not then if there is any other way to retrieve list items sorted on the basis of date....</p>