I have a written a validation Rule which makes the field required, Now Management want not to make this field required but when somebuddy enter the value, it should make sure that it is filled in the correct format.
Current formula:-
OR(
NOT(
REGEX(AppealDate__c, "[0-9]{2}/[0-9]{2}")
),
VALUE(RIGHT(AppealDate__c, 2)) > 31,
VALUE(LEFT(AppealDate__c, 2)) > 12
)
It's a Date field and the format should be like MM/DD. Can you help how to accomplish this goal.