I have a Number field that I need to be able to change the value of based on => Today's date. Is this possible with formula fields?
Field 1 = Last_Month_For_Adjustment__c //this is a date field//
Field 2 = Previous_Month_Subscription_Count__c //this is a number field//
Field 3 = Present_Month_Subscription_Count__c //this is a number field//
Required Logic- If Last_Month_For_Adjustment__c is equal to or greater than today, then Previous_Month_Subscription_Count__c would display 0, otherwise it would display value in Present_Month_Subscription_Count__c
Here is the formula that I have tried:
IF( TODAY() <= (Last_Month_For_Adj__c), "0", Present_Month_FT_Subscription_Count__c )