Filtering a table using a date range control

Showcase Tips and Hacks
1

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!

1 Like
2

@justin

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:

  • Next 7 days
  • Next 30 days
  • Next week
  • Next month

$.02

1 Like
3

@Ander great idea - I’ll pass it on to the team!

1 Like
4

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: :bulb:

image

Thanks for your active input in this community, I am learning everyday :pray:

Kind regards,
//JP

1 Like
5

@Jean_Pierre_Traets

You’re right, thanks! I modified the language in that post to be more precise. :sunglasses:

6

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]