Trying to create a formula field that will populate the opportunity dollar value if the month in the close date is January. I tried a few things but its not working. I tried putting "January" as well.

IF(  CloseDate = MONTH(01),  Amount * 0.5 , 0)


Error: Incorrect parameter type for function 'MONTH()'. Expected Date, received Number


The MONTH function needs to go around your date field, like this

IF( MONTH(CloseDate) = 1, Amount * 0.5 , 0)
  • Awesome, glad it worked! – jongpie Oct 20 '17 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy