How do I check to see if Today falls between two dates stored in a base?


I’ve got two fields - start_date and end_date for art exhibitions (just dates, no times). I’d like to add another field that checks these two with a formula and says: "If TODAY falls between these two dates (including being ON these two dates), then the exhibition is currently on. Insert ‘Yes’. If today is either BEFORE the start date or AFTER the end date, then the exhibition is not on. Insert ‘No’. "

It’s easy for me to put this into words, but I just can’t work out how to turn that into an Airtable formula. Or, more precisely, an Airtable formula that actually works!

I’ve hunted through these forums and found various approaches and none of them seem to work for me.

All suggestions gratefully received!


3 posts were merged into an existing topic: IS_BETWEEN() Date Function