Hi @d.sedlarski and welcome to Intuiface community!
As @Alex said, it’s doable and you have a good first approach. Here’s a method I’ve been using for a scenario similar to yours:
- in Airtable, add a formula column that computes if “TODAY()” is between start & end date
- in Composer, filter the content based on this column (true/false values)
Here is my demo base: https://airtable.com/shr7GnaUhYPbL850L
and the formula I use: IF(AND(TODAY() >= {Start Date},TODAY() <= {End Date}),“True”,“False”)
Let me know if that would help you.
Seb