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 comentarios