action and navigation extension

[alanwong1178]

I would like to create two buttons for user to click and filter data 1) before today() 2) on or after today() automatically

I used action and navigation extension with 'select multiple value in a field'

For selected field, I choose the order date field

In value expression: I input the following: 

= '$(= concat( distinct if([ORDERDATE.autoCalendar.Date]<today(),[ORDERDATE.autoCalendar.Date],), ';'))'

When I click on the button, nothings change and no filter applied on ORDERDATE field on the sheet.  I am wonder what I have done wrong.

This is because I used the action and navigation extension for string and numeric field like product category  or product ID before . They works fine. But when I use this extension on date type field. It does work. Please kindly help