Hi Friends,
Can someone help me to find the least date and max date from a given list of dates.
Thanks
Vani
Discussion posts and replies are publicly visible
Hi Geervanim,
use sorttextarray function is help out your requirement
find below code snippets.
local!computedDates: union(local!dates,local!dates), local!sortAscending:sorttextarray(touniformstring(local!computedDates),0), local!dateAsc: if(rule!APN_isBlank(local!sortAscending),{},todate(local!sortAscending[1])), local!sortDescending:sorttextarray(touniformstring(local!computedDates),1), local!dateDesc: if(rule!APN_isBlank(local!sortDescending),{},todate(local!sortDescending[1])),
hope this is help
Regards,
Bhanu