A simple example of how to filter a table using a date range control
https://coda.io/d/Filtering-a-table-using-a-date-picker-control_djIhIt0hmc4/Section-1_suEYn#_luN0c
Enjoy!
A simple example of how to filter a table using a date range control
https://coda.io/d/Filtering-a-table-using-a-date-picker-control_djIhIt0hmc4/Section-1_suEYn#_luN0c
Enjoy!
I was going to use that yesterday in this post: Sort table based on TODAYs date
There were no future-oriented rolling (as opposed to fixed) options though, so I created a numeric slider instead.
You guys might consider adding future-oriented rolling time blocks to the options, eg:
$.02
@Ander great idea - I’ll pass it on to the team!
Dear @Ander,
Of course you are right that it would be easy if there are some pre-set options.
Obviously it’s possible to select as following future dates:
Thanks for your active input in this community, I am learning everyday
Kind regards,
//JP
You’re right, thanks! I modified the language in that post to be more precise.
Is it possible to set CUSTOM rolling options using a formula in the Table Filter dropdown for a date range? Example: date range is after =today() - 10.
Optimally I would be able to set a “between” two custom dates. For example (in pseudocode)
AFTER [today() - 10]
AND
BEFORE [today() + 2]