I have a challenge with the List Validation process for a simple form. I need to check 2 fields: If
[NPC Status] is "Passed" and
[NPC End Date] greater or equal 2/24/2022.
=IF([NPC Status]="Passed",IF([NPC End Date]>=DATEVALUE("2/24/2022"),TRUE,FALSE),TRUE)
When I click the Ok button, the error message appears: The formula contains a syntax error or is not supported.
What is wrong with my formula? In Excel it's working as expected.