Added new Custom field "Include in Payroll File" on Team Member object. Need help with Formula data type and Checkbox output type to identify employees who meet the following requirements: are in the US, are Full Time, are Active employees and have a start date after 1/1/2018.
 
No syntax errors, but the checkbox on Team Member record is blank: (fHCM2__Has_Left__c = 'FALSE') && (fHCM2__Country__c = 'USA') && (fHCM2__Current_Employment__r.fHCM2__FTE__c >= 1) && (fHCM2__Current_Employment__r.fHCM2__Start_Date__c >= DATE(1,2,2018))

Added new Custom field "Include in Payroll File" on Team Member object. Need help with Formula data type and Checkbox output type to identify employees who meet the following requirements: are in the US, are Full Time, are Active employees and have a start date after 1/1/2018.
 
No syntax errors, but the checkbox on Team Member record is blank: (fHCM2__Has_Left__c = 'FALSE') && (fHCM2__Country__c = 'USA') && (fHCM2__Current_Employment__r.fHCM2__FTE__c >= 1) && (fHCM2__Current_Employment__r.fHCM2__Start_Date__c >= DATE(1,2,2018))