I wanted a validation to restrict the record creation/ update for following Fields that need to be restricted % Test (Data Type Percentage), Month (Picklist) Values Jan, Feb ..... Dec) Year (Picklist) Values ( 2018, 2019 ......)
Expected Result: 1. The user creating/ updating records for past months should not receive the validation error. 2. The user creating/updating records for current/future month should receive the validation error
I have created a custom field formula filed Modified date which is converting the Lastmodifieddate filed from date time to date field.
OR( MONTH(Modified_date__c) <> MONTH(TODAY()), YEAR(Modified_date__c) <> YEAR(TODAY()) )
this is not working. Need help.