Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Danielle SDanielle S 

Close date

Hi everyone, 
I'm looking for a solution to encourage users to update the Close date. Indeed, close date we have in reports are not accurate , some of them are in the past ! 
Can we employ validation rules to solve this issue ? 
thank you for your help 
 
Best Answer chosen by Danielle S
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Daya,

In this scenerio you can use the validation rule as below but Validation rule only fires when a record is created or edited but not with out any action.
  
CloseDate < Today()
Let me know if you need any other help.

If this solution helps, Please mark it as best answer.

Thanks,

All Answers

Sai PraveenSai Praveen (Salesforce Developers) 
Hi Daya,

Is that opportunity. If so close date is already mandatory by  default. If there is any custom object or field you have to use the validation formula as below.
  
isBlank( Closed_Date__c )

If this solution helps, Please mark it as best answer.

Thanks,
​​​​​​​
Danielle SDanielle S
Actualy, it is under Opportunity. the close date is mandatory but users don't update this date when this date has passed and the opportunity still open. we would like to encourage users to review the date and update it.
thank you for you help 
 
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Daya,

In this scenerio you can use the validation rule as below but Validation rule only fires when a record is created or edited but not with out any action.
  
CloseDate < Today()
Let me know if you need any other help.

If this solution helps, Please mark it as best answer.

Thanks,
This was selected as the best answer
Danielle SDanielle S
thank you for you answers. it helps