+ 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 ?