I have some requirement to create a formula that evaluates if Fiscal Year >= Current FY, then returns true.
So our fiscal year starts on July 1 and ends June 30.
6/30/2018, it is in FY18, wheras
7/1/2018, it is in FY19.
Our Fiscal Year field is a picklist field with the following values: 18-19, 19-20, 20-21, 21-22 etc.
I am trying to compare it to the current date, which is Today() to see if it would evaluate to true or not but it has been given me false the whole time.
Anyone willing to help troubleshoot? Thanks!
This is what I have:
IF( VALUE(RIGHT(TEXT(Fiscal_Year__c),3)) >= IF( VALUE(TEXT(MONTH(TODAY()))) >= 6, VALUE(LEFT(TEXT(YEAR(TODAY())),2)), VALUE(LEFT(TEXT(YEAR(TODAY())+1),2)) ), "True", "False" )