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
kstites1kstites1 

Formula Field Broken

This doesn't recognize the close date filter.  Can someone help?

 

IF( RecordTypeId ="0123000000004s7" ,null,IF(AND( Amount <>0,CloseDate > (2009-03-31)),".6",JP_Points_1__c + JP_Points_2__c + JP_Points_3__c))
 

 
 
 


Best Answer chosen by Admin (Salesforce Developers) 
mpannmpann
Try this:
 
IF( RecordTypeId ="0123000000004s7" ,null,IF(AND( Amount <>0,CloseDate > DATE(2009,03,31))),".6",JP_Points_1__c + JP_Points_2__c + JP_Points_3__c))
 
Date is a datatype and needs to be compared to other dates (or date/time) values. 
Message Edited by mpann on  08-20-2009 07:47 PM


All Answers
Barb Rheaume @ MTSBarb Rheaume @ MTS
This is a piece of a data validation rule, but I was able to get logic to work based on this:
I'm looking for oppty created after June of 2007.
 
OR(AND(YEAR( DATEVALUE( CreatedDate )) = 2007, MONTH( DATEVALUE( CreatedDate )) >= 6), 
YEAR( DATEVALUE( CreatedDate )) >= 2008)), 
 
Does that help? 
 


mpannmpann
Try this:
 
IF( RecordTypeId ="0123000000004s7" ,null,IF(AND( Amount <>0,CloseDate > DATE(2009,03,31))),".6",JP_Points_1__c + JP_Points_2__c + JP_Points_3__c))
 
Date is a datatype and needs to be compared to other dates (or date/time) values. 
Message Edited by mpann on  08-20-2009 07:47 PM
This was selected as the best answer
kstites1kstites1
IF( RecordTypeId ="0123000000004s7" ,null,IF(AND( Amount <>0,CloseDate > DATE(2009,03,31))),6/10,JP_Points_1__c + JP_Points_2__c + JP_Points_3__c))
 
The only thing I had to change after this was to make both values a number instead of text and it works perfect thanks!