You need to sign in to do that
Don't have an account?
Ro Valiao
Show "this month" in a formula
Hey guys, I am stuck on this formula, maybe you can help...I am trying to say, if the close date is not blank and if the close date is this month, then return MRR.
Check it out:
IF(AND(NOT(ISBLANK(CloseDate)),CloseDate=MONTH(today())),MRR__c , null)
I am getting this error "Error: Incorrect parameter type for operator '='. Expected Date, received Number"
.
I am unsure on how to show a date for "this month". Any ideas?
Check it out:
IF(AND(NOT(ISBLANK(CloseDate)),CloseDate=MONTH(today())),MRR__c , null)
I am getting this error "Error: Incorrect parameter type for operator '='. Expected Date, received Number"
.
I am unsure on how to show a date for "this month". Any ideas?
Hope this helps out for you. Hit like if you are able to solve your issue so that i would be a future reference to others
IF(AND(NOT(ISBLANK(CloseDate)),MONTH(CloseDate)=Month(today())),MRR__c , null)
yo do not need to check for blank becuase if close date is blank
MONTH(CloseDate)=MONTH(today()) and
YEAR(CloseDate)=YEAR(today()) will be false