function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dandydandy 

Rookie looking for formula advice

Hi All,

 

Can some please review this and let me know what the formula below means?  I ran a check syntax and it was approved but the function isn't doing what I want it so I must have an error:

 

Integration_Pendig_Due_Date__c < DATE( YEAR(TODAY()) , (DAY(TODAY()) - 7), DAY(TODAY()))

 

I'm trying to create a formula to run when the Release Date field (Integration_Pendig_Due_Date__c) is less than 7 days out. 

 

Thanks in advance for your help :smileywink:

KevinLaurenceKevinLaurence

Can't you just use Integration_Pendig_Due_Date__c < TODAY() - 7 ?