You need to sign in to do that
Don't have an account?
Kyriacos
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?
(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?
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