Get Max Date Using CAML Query From alist

Question

Dear all, how can i get max Date and Min Date from a list Date Column

Answer 1

The brute force approach is to create two queries that will retrieve the list content sorted by date asc and desc. I know that this sucks but at least you can move on with you project and refine the query later on.

If only it was possible to retrieve top 1 then it might even work in production.