+ Start a Discussion
lil_rangerlil_ranger 

validation rule to prevent ticket creation

AND(
Entitlement.EndDate < DATEVALUE(CreatedDate),
ISPICKVAL(Status, 'Open'),
$RecordType.Id = '0123000000008xP'
)

 I'm trying to write a validation rule to not allow a ticket to be created if the entitlement end date is less than the created date of the ticket.   Any ideas on what I did incorrectly?  

Best Answer chosen by Admin (Salesforce Developers) 
Steve MolisSteve Molis

"Charlie, here comes the deuce. And when you speak of me, speak well." -   Crash Davis, Bull Durham

 

AND(
ISNEW(),
Entitlement.EndDate < TODAY(),
ISPICKVAL(Status, 'Open'),
$RecordType.Id = '0123000000008xP'
)

 

All Answers

Steve MolisSteve Molis

"Charlie, here comes the deuce. And when you speak of me, speak well." -   Crash Davis, Bull Durham

 

AND(
ISNEW(),
Entitlement.EndDate < TODAY(),
ISPICKVAL(Status, 'Open'),
$RecordType.Id = '0123000000008xP'
)

 

This was selected as the best answer
lil_rangerlil_ranger

Thank you!  I guess I owe you a beer.

Steve MolisSteve Molis

You guessed right!  ;-D