Smart formulas for your Lime filters

Seven days ahead

DateAdd("d", +7, Date)

How many days back do you want to be able to see?

DateAdd("d", -(InputBox("How many days do you want to be able to see?", "Number of days")), Date)

Logged in user

ActiveUser.Record.ID