Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
cldavecldave 

Help with syntax for validation rule

Hi trying to make a validation rule with those criterias:

 

-If Estimated value = null

and Status picklist value =faxed

and date fax sent is greater than 11/1/2013

 

here's what i wrote so far, but i seem to have an error somewhere as when i try to save a lead with the first 2 criterias but date fax sent older than 11/1/2013 i still get validated and cannot save lead.

 

 

formula:

AND(
NOT($Profile.Name = "System Administrator"),
ISNULL( Estimated_Value__c ),
ISPICKVAL( Status, "Faxed"),
Date_Fax_Sent__c > date(11,1,2013 ))

 

 

If someone could help me out I would appreciate

 

 

thx in advance

Best Answer chosen by Admin (Salesforce Developers) 
gautam_singhgautam_singh

Hi, 

 

Please try this , It will work taking Esitmated Value as a Text Field

AND( ISBLANK( Estimated_Value__c ) , 
ISPICKVAL( Status__c , "Faxed"), 
( Date_Fax_Sent__c > DATE(2013,11,1)) )

 


Hope this fulfills your requirement. 


Important :

Click on the Star Icon aside if this post provides you with useful information and if this is what you where looking for then please mark it as a solution for others benefits.

Thank You

All Answers

kevin lamkevin lam

The syntax of the DATE function is DATE(year,month,day).
gautam_singhgautam_singh

Hi, 

 

Please try this , It will work taking Esitmated Value as a Text Field

AND( ISBLANK( Estimated_Value__c ) , 
ISPICKVAL( Status__c , "Faxed"), 
( Date_Fax_Sent__c > DATE(2013,11,1)) )

 


Hope this fulfills your requirement. 


Important :

Click on the Star Icon aside if this post provides you with useful information and if this is what you where looking for then please mark it as a solution for others benefits.

Thank You

This was selected as the best answer
cldavecldave

Thank you guys for you help, that worked :)