+ Start a Discussion
Aaliya YusufzaiAaliya Yusufzai 

Validation Rule based on Stage & Created Date

Hello,  I am trying to create a validation rule, so that an Opportunity cannot change to a certain Stage Value, once the Opportunity Created date is greater than 30 days.
The Stage Value  is "No Opportunity"

Here is the validation that I have created and It is not working:
AND(ISPICKVAL(StageName, "No Opportunity"), 
(DATEVALUE(CreatedDate) > TODAY() + 30))

If someone can help please.
Best Answer chosen by Aaliya Yusufzai
hitesh90hitesh90
Hello Aallya,

Please try below validation rule.
Validation Rule Formula:
AND(ISPICKVAL(StageName, "No Opportunity"),
((Now() - CreatedDate) > 30))

Let me know if you have any question on this. Please mark this "Solved" if it helps.

Thank You,
Hitesh Patel
Email :- hiteshpatel.aspl@gmail.com
http://mrjavascript.blogspot.in/

All Answers

hitesh90hitesh90
Hello Aallya,

Please try below validation rule.
Validation Rule Formula:
AND(ISPICKVAL(StageName, "No Opportunity"),
((Now() - CreatedDate) > 30))

Let me know if you have any question on this. Please mark this "Solved" if it helps.

Thank You,
Hitesh Patel
Email :- hiteshpatel.aspl@gmail.com
http://mrjavascript.blogspot.in/
This was selected as the best answer
Aaliya YusufzaiAaliya Yusufzai
Thank you so Much!!  That worked