You need to sign in to do that
Don't have an account?
KNK
Validation for current year and Next year
Hi Team,
I want to create a validation that only current year and next year values can be created on a object,
I am trying in with below way, but it is showing error Missig )'
OR (
YEAR(Sales_Plan__c ) <> YEAR (today().year() ),
YEAR(Sales_Plan__c ) <> YEAR (today().year() + 1 )
)
Can any one help me on the same
All Answers
OR(
YEAR(Sales_Plan__c) < YEAR(TODAY()),
YEAR(Sales_Plan__c) > (YEAR(TODAY()) + 1))
Again it is showing same error with the below one.I chaned year to Text as that filed is Text data type
OR(
"TEXT"("Sales_Plan__c") <> YEAR(TODAY()),
"TEXT"("Sales_Plan__c") <> (YEAR(TODAY()) + 1)
)