Skip to main content

📆 Relative Date Input

Last week I painstakingly constructed a “relative date input” using:

  1. A numeric input parameter (n_periods_ago)

  2. A text input parameter (period_grain)

  3. 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 🎉.