Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I would rather use below as search string
='>'&Date(Max(Date-7),'DD-MM-YYYY')&'<='&Date(Max(Date),'DD-MM-YYYY')
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