+ Start a Discussion
Rung41Rung41 

Validation Rule for Address Required on new and current Accounts

Curently I have the following validation rule that requires the Billing Address field to be required. The issue I am having is it does not work when a user creates new Account. Only works after the Account has been saved and then is updated.  How to get the validation to apply  when a user creates a new Account?

AND (
      DATEVALUE( CreatedDate )  >=   DATEVALUE('2011-06-01'),
OR(
ISBLANK( BillingStreet ),
ISBLANK( BillingCity ),
ISBLANK( BillingState ),
ISBLANK( BillingPostalCode )
))
Vinit_KumarVinit_Kumar
Remove the CreatedDate part from your validation rule and that should do the trick i.e. 
OR(
ISBLANK( BillingStreet ),
ISBLANK( BillingCity ),
ISBLANK( BillingState ),
ISBLANK( BillingPostalCode )
)
If this helps,please mark it as best answer to help others :)
AgiAgi
Hi,


AND (

OR(
ISNEW(),
DATEVALUE( CreatedDate )  >=   DATEVALUE('2011-06-01')),

OR(
ISBLANK( BillingStreet ),
ISBLANK( BillingCity ),
ISBLANK( BillingState ),
ISBLANK( BillingPostalCode )
))