Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to create a button that toggles a filter for all past dates.
The field is called "date2".
I have tried:
Toggle selections, select values in feild, =IF(Date2<Date(Today()),Date2,'') , Date2<Date(Today())
and a few others but no success.
Please help me many thanks
Please try to create a button that filters all past dates by using the “Select values in field” action and entering the following expression in the “Search String” field:
=if(Date2 < Today(), Date2)
Thanks, for the suggestion but doesn't work
The format of Date2 is DD/MM/YYYY
Just to add