Select in Field: values greater than

[#1]

Hello Guys,

i need your help, i want make this action when i open a sheet:

if(DATE>=date(today()-31), DATE)

Well, i go to the select in field and i set the trigger but this one not work.

Any suggestions?

Thank you

Alfonso

[Gysbert_Wassenaar]

Try ='>' & date(today()-31) as search string

[Anonymous · Accepted solution]

Just a very small correction:

='>=' & date(today()-31)