Skip to main content
Wendy Legorreta (Ascension) 님이 Who owes me a beer?!?에 글을 올렸습니다

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