function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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

Date Validation Rule

Hello,

 

I have a checkbox field called Free Trial, if free trial is checked then I need to have the Length of Free Trial field completed.  I currently have this validation rule complete.

The Length of Free Trial field is a picklist.  Choices are 30 days, 60 days, and 90 days.  We also have a start and end date field.  For example; If 30 is selected in the Length of Free Trial, and the start date is 2/1/2010, can you create a validation rule and then a workflow that populates the end date appropriately?  I understand the workflow, but the validation rule has me puzzled.

 

Thanks,

Phillies Fan

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

How about if you just made your End Date field a Formula(Date) with a formula like this?

 

 

StartDate_Fieldname +
CASE(Picklist_Fieldname,
"30 Days", 30,
"60 Days", 60,
"90 Days", 90,
0)
 
 
 
Message Edited by Stevemo on  02-09-2010 03:58 PM


All Answers
Steve :-/Steve :-/
How about if you just made your End Date field a Formula(Date) with a formula like this?
 
 
StartDate_Fieldname +
CASE(Picklist_Fieldname,
"30 Days", 30,
"60 Days", 60,
"90 Days", 90,
0)
 
 
 
Message Edited by Stevemo on  02-09-2010 03:58 PM
This was selected as the best answer
PhilliesFanPhilliesFan
Thank you, this is great