+ Start a Discussion
Naveen DhanarajNaveen Dhanaraj 

Create a validation rule that Date Of Birth should not be equal to today

I have field called DOB (date type).I have created a validation rule that Date Of Birth  should not be equal to today  === (DOB__c <> TODAY())
 But its not working
Best Answer chosen by Naveen Dhanaraj
mritzimritzi
Validation Rule works the opposite way.

To get error message, you have to write
DOB__c = TODAY()

Mark this as Best Answer, if this solves your problem

All Answers

mritzimritzi
Validation Rule works the opposite way.

To get error message, you have to write
DOB__c = TODAY()

Mark this as Best Answer, if this solves your problem
This was selected as the best answer
veda Hebbarveda Hebbar
Hi Naveen,

Please try below formula in your validation rule:
 
DOB  = TODAY()


This will thown an validation error if you are trying to make DOB = today()

Thanks,
Veda
Ranjeet Kumar 40Ranjeet Kumar 40
Hi  Naveen Dhanaraj,
I think you should use this validation rule :
DOB__c >= TODAY()
because Date of birth must be less than or equal to today.

Thanks,
Ranjeet.
 
Dell IndiaDell India
Validation Rule works in opposite
U have to give below condition
DOB__c   >=  TODAY()
So that user can not enter a date that is more than today