You need to sign in to do that
Don't have an account?
Joanna Kirk
How do I create a field for 'year' (with a validation rule that it cannot be in the future)?
e.g. trading since (year)
I've been told to start with a number field (4 digit limit) but need a hint on where to start with the sytax! Any help appreciated.
I've been told to start with a number field (4 digit limit) but need a hint on where to start with the sytax! Any help appreciated.
All Answers
You can create avalidation rule with the below formula,
Where Year__c is a custom field of number type and is chakced against the year of today. Please let me know if this helped you.
Thanks,
Shyama
The number displays with a comma, e.g. '2,015' - Is there any way to show this differently?
If not, should I change the data type to something else?
Thanks
so all 4 digits, say, starting from 1300 to Year(TODAY ()) .
I'm not sure if I'm going in the right direction, but think I need to include some of the followng elements somehow: AND IF (Value(Year__c) == 4, true, false)
Thanks and have a great day Shyama.