Filtering based on Time

Hey all,

I’m in the textile business and I use glide to keep everything in 1 spot between my team and the suppliers. I’m currently working on a homepage where I want to show a container that displays upcoming deadlines. In the container I have a table that shows all the orders. Now I want to be able to filter these orders and only make them show if the ETD is within the next 2 weeks for example.
Anyone knows how to do this?

  • In your table, create a Math column that has the formula: N+14 with N being “Now” value.
  • You now have the value of “2 weeks later”. Filter the collection so that the ETD value is on or before the “2 weeks later” value, and after now.
2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.