I wrote an If Else statement in a formula tool to capture the months that are less than or equal to the "End of Month" date based on today's date. The issue is that it should also be capturing row 4 as the End of Month is 2026-04-26 (so less than today's date 2026-04-01). However it is not, and the Range column is stated as "No." I tried another formula thinking it would work, but it is not also.
Original Formula that doesn't work:
if [End of Month] >= [Current Fiscal Month]
then 'No'
else 'Yes'
endif
New Formula that doesn't work:
if min([Current Fiscal Month], [End of Month])=[Current Fiscal Month]
then 'No'
else 'Yes'
endif
Why is that? Prior please help and thank you!
