Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to create a button that chooses the last five dates of all the dates included in my data. How can I do this?
Someone else suggested that I do Date(Today()), but that chooses the last 5 days before today, rather than from the dates in the data.
I tried with the numeric date, it works okay, couldn't get it worked though with the date field yet.
Load *,Num(Date) as DateNum inline [Date01/01/202101/31/202102/15/202102/28/202103/10/202103/20/202104/01/202104/15/202105/10/202105/25/2021];
Expression used in button action as -
='($(=max(DateNum))|$(=max(DateNum,2))|$(=max(DateNum,3)))'