You need to sign in to do that
Don't have an account?
Rung41
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 )
))
AND (
DATEVALUE( CreatedDate ) >= DATEVALUE('2011-06-01'),
OR(
ISBLANK( BillingStreet ),
ISBLANK( BillingCity ),
ISBLANK( BillingState ),
ISBLANK( BillingPostalCode )
))
AND (
OR(
ISNEW(),
DATEVALUE( CreatedDate ) >= DATEVALUE('2011-06-01')),
OR(
ISBLANK( BillingStreet ),
ISBLANK( BillingCity ),
ISBLANK( BillingState ),
ISBLANK( BillingPostalCode )
))