function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
KyriacosKyriacos 

Formula not displaying correct result

I have created a report with the following criteria:

(Last Funding Date OR Date of Last Activity) AND Contact Prefrence Email

When i try to reproduce this as a formula field to tick a checkbox i receive different results.

IF(Last_Funding_Date__c >= DATE( 2018, 9, 1 )||Date_of_Last_Activity__c >= DATE( 2018, 9, 1 ) && Contact_preference_Email__c = TRUE,TRUE,

FALSE
)

How i written the formula correct?
ShirishaShirisha (Salesforce Developers) 
Hi Kyriacos,

Greetings!

I can see that the result is the boolean value and If the given criteria doesnot match then you will get False as result.

And,if you use it as criteria on the report then you will get the records that match the given dates.

So,the result depends on the area where we use it as criteria.

Kindly mark it as best answer if it helps so that it can help others in the future.

Warm Regards,
Shirisha Pathuri