SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have sharepoint list with data and one of the columns contains date ... how can i programmatically retrieve the latest date, the field is a Date And Time type?

share|improve this question
up vote 2 down vote accepted

You need to order by the column (descending), then set the query's rowlimit to 1:

<OrderBy>
    <FieldRef Name="YourColumn" Ascending="FALSE" />
</OrderBy>

From here: SO: MAX query using CAML

share|improve this answer

You can use foreach loop against your list's date column and then compare it with datetime.now to get latest date.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.