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 [
Date
01/01/2021
01/31/2021
02/15/2021
02/28/2021
03/10/2021
03/20/2021
04/01/2021
04/15/2021
05/10/2021
05/25/2021
];
Expression used in button action as -
='($(=max(DateNum))|$(=max(DateNum,2))|$(=max(DateNum,3)))'