Button that filters all past dates

[CBoardy]

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

[Chirantha]

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)
 

[CBoardy]

Thanks, for the suggestion but doesn't work

The format of Date2 is DD/MM/YYYY 

Just to add