Active validation rule, one time.

[eduardofernandes]

Good morning.

I have a problem.

How to I create a validation rule, but it works once.

I have a validation rule That test date if the date of close field, equals is today. After i have closed and the opportunity won this validation is activate, but I want to perform this validation rule not more.

Thanks for replies.

[eduardofernandes]

AND(
   ISPICKVAL( StageName, "Fechado e ganho"),
   IF(TODAY() < CloseDate || TODAY() > CloseDate ,true,false), 
   NOT(
      ISPICKVAL(PRIORVALUE( StageName), "Fechado e ganho" )
   )
)

It's work. But is it?

[techman97]

Validation Rules by themselves are desiged to always be active - you have to create a field to "shut it off" via logic.

You're probably going to need another custom field (checkbox I would recommend) that would be updated to TRUE (via workflow) once the condition is met where you don't want to have the Validation Rule fire anymore.  You'd then add that new field into your "AND" logic.