Skip to main content
Topics#Data ManagementAbby Douglas's Question
Abby Douglas asked in #Data Management
Dec 18, 2015, 9:28 PM

Formula Help: Check box if date in field is within the last 2 years

I need to write a formula to check a box if a date follows within the last two years. 

 

Here is the formula I wrote, but all boxes are being checked and I don't know what I'm doing wrong.

 

IF(YEAR(Account.Marketing_Lead_Date__c) - YEAR(TODAY()) <= 2, TRUE,FALSE)

 

I'm having trouble wrapping my head around it... must be because it's Friday! 

 

Thank you so much for your help!
8 answers
  1. Sunil Sarilla (M&G Investments)
    Dec 18, 2015, 9:55 PM
    Hi Abby,

     

    could you please post the screenshot of the record where this is failing.

     

    Please try the below

    IF(
    (YEAR(TODAY()) - YEAR(Account.Marketing_Lead_Date__c)) <= 2,
    TRUE,
    FALSE
     )

     

     
Write an answer...
0/9000