Triggers on open - Day interval

[#1]

Hi

I would like to make a trigger on open a document. i would like to have the date period from today-5 until today-1. But I can't get it work.

This works, but how do I make it so it becomes the interval?

= Date(today()-1)

[Gysbert_Wassenaar · Accepted solution]

Are you looking for a search string for a Select in Field action?

= '>=' & date(today()-5) & '<=' & date(today()-1)

[#3]

yes that was it. Thank you sir