Skip to main content

Hi everyone, 

I'm looking for some assistance with finding a date "THIS MONTH" in a formula checkbox field. 

I have a field where the box needs to be checked on a contract object if the auto renewal term = 1 AND the contract end date is less than or equal to "THIS MONTH". My current formula I have is:

 

AND(AutoRenewalTerm__c = 1,

MONTH(EndDate) <= MONTH(TODAY()), true)

 

It's checking the box if the auto renewal term = 1 regardless of the date. What am I missing in the formula to capture the contract end date is less than or equal to this month? 

4 件のコメント
0/9000