How you will write Validation rule for above scenario while inserting the record and Validation rule should not fire while updating form workflow it show be accept.
You can use the ISNEW() function for the validation rule to be triggered only on record creation. Another point to be noted is that validation rules are never triggered when a record is updated through a workflow. So you really need not explicitly put any logic for that in your validation formula.
Please check the point no 12 in the below link which clearly exlpains that validation rules are not re-triggered on workflow field updates.
Can you explain your scenario..
while inserting the record Validation rule should not fire but while updating form workflow it show be accept.
You can check the record is new or existing one using ISNEW() function in formula.
Ex:
Please let me know, if it helps you.
Best Regards,
Dayakar.D
You can use the ISNEW() function for the validation rule to be triggered only on record creation. Another point to be noted is that validation rules are never triggered when a record is updated through a workflow. So you really need not explicitly put any logic for that in your validation formula.
Please check the point no 12 in the below link which clearly exlpains that validation rules are not re-triggered on workflow field updates.
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_triggers_order_of_execution.htm