+ Start a Discussion
Karen Brown 39Karen Brown 39 

Checking if a date field is blank for data scoring?

Hi, I have a number of checkbox fields that need to be completed and if they are missing i have created a text formula field to display missing data, however I have 1 field that is a date field and if this is blank needs to return that taht date field is missing;

Here is my formula without the date field and works perfectly

Data TypeFormula  
IF( Completeness_AML_Searches__c =100,"All Details Captured", 
"" 

&IF (Graydon_company_search_completed__c = False, "Graydon company search, ","")&"" 
&IF (World_Check_completed__c = False, "World check , ","")&"" 
&IF (Companies_House_checked__c = False, "Companies house , ","")&"" 
&IF (CreditSafe_checked__c = False, "Creditsafe , ","")&"" 
&IF (Land_registry_search_completed__c = False, "Land registry search, ","")&"" 
&IF (Net_worth_validated__c = False, "Net worth validated, ","")&"" 
&IF (Google_search_conducted__c = False, "Google search, ","")&"" 
&IF (Law_society_confirmed__c = False, "Law society confirmed, ",""))

However when I add the date field the syntax errors.. can someone help or suggest how i add an addtional line to check the date field...i cannot add as below;

&IF (Call_Credit_checked__c= False, "Call credit, ","")&"" 

IF(  Completeness_AML_Searches__c  =100,"All Details Captured", 
"" 

&IF (Graydon_company_search_completed__c = False, "Graydon company search, ","")&"" 
&IF (World_Check_completed__c = False, "World check , ","")&"" 
&IF (Companies_House_checked__c = False, "Companies house , ","")&"" 
&IF (CreditSafe_checked__c = False, "Creditsafe , ","")&"" 
&IF (Land_registry_search_completed__c = False, "Land registry search, ","")&"" 
&IF (Call_Credit_checked__c  = False, "call credit, ","")&"" 
&IF (Net_worth_validated__c = False, "Net worth validated, ","")&"" 
&IF (Google_search_conducted__c = False, "Google search, ","")&"" 
&IF (Law_society_confirmed__c = False, "Law society confirmed, ",""))

I get this error - Error: Incorrect parameter type for operator '='. Expected Date, received Boolean
StephenKennyStephenKenny
The date field is not a checkbox, therfore it wont have a (boolean) true or false value. Instead, it will either contain a date or it wont.

Try using this line instead:
&IF (ISBLANK(Call_Credit_checked__c), "Call credit, ","")&""