Last week I painstakingly constructed a “relative date input” using:
A numeric input parameter (n_periods_ago)
A text input parameter (period_grain)
A python cell (to calculate the right start_date)
Today, I replaced it with a brand new relative date input parameter! When configuring a date input, you can allow relative date inputs and users will be able to choose “Today”, “Yesterday”, etc. instead of picking a specific date.
The best part of this is that relative dates will always be up-to-date, so if you write a query filtered on “Today” or “Yesterday”, every time that app runs the output will be accurate 🎉.