Button to select date inferior/superior

[MNicolas]

Hi all,

I want to select the dates inferior to my previous week

I added a button with Selection on a field. I can select one special date  but how can I put the sign inferior  ?

I tried ='<' & (today()-8)*1 and much more but it didn't work

Thanks for your help

[Anil_Babu_Samineni]

I would rather use below as search string

='>'&Date(Max(Date-7),'DD-MM-YYYY')&'<='&Date(Max(Date),'DD-MM-YYYY')

[MNicolas]

In the filter it work fine, but in the button I tried ='<'& Date(today()-7,'DD/MM/YYYY') or ='<'& (today()-7)*1 and get nothing... (same with max date)

Even ='<20/05/2020' or <20/05/2020 doesn't work

 works

 nothing happens