The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I’m trying to extend a function that I previously got some help with on this forum.
My use case is a base for storing details on art exhibitions, with fields for a start and end date for each exhibition.
With help, I got the formula working when it w...
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...
Thank you very much, especially for the explanation.
Just one minor correction needed - a comma after ‘Already finished’, then it was perfect.
IF(
IS_AFTER(
{Start_date},
TODAY()
),
“Not yet started”,
IF(
IS_AFTER(
TODAY(),
{End_date}
),
“Already f...
Brilliant! Thank you so much for this!
For the benefit of anyone else reading this, I couldn’t find an “IS_BETWEEN” function as such, but the link goes to a thread which describes how to achieve exactly what I wanted using “IS_BEFORE” and “IS_AFTER”...
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...