Hi,
I have to enable birthdate remainder boolean check on contact, If the contact birthdate reaches to 20, 21 and 28 years with in 40 days of the contact birthdate. for example if the contact reaches 20 years in next 40 days then we have to enable boolean check on contact that means we have to enable boolean after contact age is 19 years 10 months and 20 days till he reaches to 20 only not more than 20 like wise for 21,28 years.
I tried following formula but it is not working as expected and It considers the after 20 years and 40 days also but I want before 40 days.
IF( AND( NOT( ISBLANK( Birthdate ) ) , OR(YEAR(TODAY()+40) - YEAR(Birthdate) = 20,YEAR(TODAY()+40) - YEAR(Birthdate) = 21,YEAR(TODAY()+40) - YEAR(Birthdate) = 28),DATE(YEAR(TODAY()),MONTH( Birthdate ),DAY(Birthdate )) <= (TODAY() + 40)) , true,false)

Thanks,
Mohan