Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

2 Answers 2

up vote 2 down vote accepted

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

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

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


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.