This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
