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