Getting latest datetime from a splist

Question

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?

Answer 1

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

Answer 2

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