2

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?

2

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

-1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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