compare list of dates to findout least date and max date

Question

Hi Friends, 
 Can someone help me to find the least date and max date from a given list of dates. 
 
 Thanks

ankitab0001 · Answer

Hi geervanim 
 Check this out ! 
 load(
 local!dateList:{today(),today()+1, today()-2, today()+5},
 {
 minDate:todate(min(local!dateList)),
 maxDate: todate(max(local!dateList))
 }
)

compare list of dates to findout least date and max date

Top Replies