You need to sign in to do that
Don't have an account?
Siva Sakthi
How to set the validation for DOB as Text Field not in Future Year?
Hi ,
I have DOB as Text Field, I want to given the validation for this text Field (DOB) ?
My Sample Validation is : TEXT(SitEduTest__Academic_Year__c < Today())
But it causing Error: Incorrect parameter type for operator '<'. Expected Text, received Date. How to achive this guide me .
Thanks
Maheshwar
I have DOB as Text Field, I want to given the validation for this text Field (DOB) ?
My Sample Validation is : TEXT(SitEduTest__Academic_Year__c < Today())
But it causing Error: Incorrect parameter type for operator '<'. Expected Text, received Date. How to achive this guide me .
Thanks
Maheshwar
VALUE(SitEduTest_Academic_Year__c) > YEAR(TODAY())
Thanks,
Vinoth
All Answers
Please try the below formula,
DATEVALUE(SitEduTest_Academic_Year__c) > Today()
I have tried with Date format : 2015-09-15
Thanks,
Vinoth
I have one more doubt In my text field i have entered only year (2000,2015, etc..) I want to validate the current year validation. Like any body enter future year means throw an error. 2018,2017 etc....
How to achive this only year validation in the Text field.
Advance Thanks
Maheshwar
VALUE(SitEduTest_Academic_Year__c) > YEAR(TODAY())
Thanks,
Vinoth