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
Dave The RaveDave The Rave 

Syntax formula

Hi All,

I wrote a formula that works for a formula field, but I need to replace TODAY() with DateMeeting__c:

1) This works:

((((YEAR(Contact__r.FirstCertRegFromDate__c))=YEAR(TODAY())) && (Contact__r.FreePointsRequired__c=Contact__r.FreePointsObtainedYear1__c)))

2) This is the amended version, but has a syntax error:

((((YEAR(Contact__r.FirstCertRegFromDate__c))=YEAR(DateMeeting__c)) && (Contact__r.FreePointsRequired__c=Contact__r.FreePointsObtainedYear1__c)))

Can anyone help me correct the 2nd formula? is there not also a tool to help SF Admins correct formulas? maybe with difference colours for each bracket set?

Thanks,

Dave
Raj VakatiRaj Vakati
Try this
  
(YEAR(Contact__r.FirstCertRegFromDate__c)==YEAR(DateMeeting__c)) && 
(Contact__r.FreePointsRequired__c==Contact__r.FreePointsObtainedYear1__c)