+ 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) 
SteveMo__cSteveMo__c

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

SteveMo__cSteveMo__c

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