Forum Discussion

StephenMadison's avatar
Qrew Cadet
3 years ago

Creating Formula Multi-Select Field to Display Fiscal Years between 2 Dates

My dilemma is that I would like to create a formula multi-select field that shows which fiscal years the range between 2 dates contains.

For instance, our fiscal years are between Sept 1st and August 31, If I have a Start Date of 09/01/2018 and  07/01/2020,  I would like the formula multi-select field to display that this range is in FY19 FY20 FY21.

My Initial thought was to somehow make a continuous if statement with the different Fiscal Year formulas, but I think that is inefficient.  If anyone has any ideas I'd love to hear them.

No RepliesBe the first to reply