how can i get max Date and Min Date from a list Date Column
Asked
Active
Viewed 2,358 times
3
-
Thank you for this good answer but if i want to you GroupBy Tag to do this , how can i implement this soluation – Mohamed Bakr Apr 26 '09 at 11:46
-
See also: http://stackoverflow.com/questions/516073/max-query-using-caml – Stu Pegg Dec 20 '12 at 10:33
1 Answers
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.
Kasper
- 1,710
- 2
- 17
- 31
-
Thank you for this good answer but if i want to you GroupBy Tag to do this , how can i implement this soluation – Mohamed Bakr Apr 26 '09 at 11:47