You need to sign in to do that
Don't have an account?
Validation Rule Help
I'm trying to create a validation rule the checks two date fields to
make sure they match as long as one of them has been filled. If the
custom field is empty, nothing happens, but if the custom field has a
date in it, the date is checked with the "CloseDate" field.
"CloseDate" must equle "datasynchqbod__QB_Transaction_Date__c" but only
if datasynchqbod__QB_Transaction_Date__c has been filled in.
The
"datasynchqbod__QB_Transaction_Date__c" is defaulted to be blank. Once
the Opportunity is moved to closed Won the opportunity is synced with an
external system and datasynchqbod__QB_Transaction_Date__c gets a date
entered into it. We need that date to stay synced with "CloseDate"
going forward. The two fields must be equal once something is entered.
Thanks so much for your help,
JEremy
If(datasynchqbod__QB_Transaction_Date__c!=null&&datasynchqbod__QB_Transaction_Date__c!=closeddate)
Then display error.