I have a requirement where I need to populate records where a criteria is true. The criteria is the users must have joined in between Jul,2018 to May,2019. I thought I can achieve this using a formula field. Below is the formula:
AND((Join_Date__c >= DATE(2018,07,01)),(Join_Date__c <= DATE(2019,04,30)))
this would return true if both the conditions satisy. But when I see in the record, it is displayed as "#Error!" instead of true or false
I do not understand where I have done a mistake. Can anyone please help me with this.
true
in the formula field if joining date falls in your criteria, andfalse
otherwise. Is it?