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
SF Buzz VutukuriSF Buzz Vutukuri 

Workflow to send email


Hi,
I want workflow to send email if the diffrence between created date and closed date of the opportunity is less than 15 days.............
Best Answer chosen by SF Buzz Vutukuri
John PipkinJohn Pipkin
My fault. Should be  
CloseDate - DATEVALUE(CreatedDate) < 15

 

All Answers

John PipkinJohn Pipkin
You'll need to create a new Workflow Rule on the Opportunity. The logic would be: 
DATEVALUE(CloseDate) - DATEVALUE(CreatedDate) < 15

Then set up the workflow rule to fire an email.

Hope that helps
SF Buzz VutukuriSF Buzz Vutukuri
No it's not working, I am getting error "Incorrect argument type for function DATEVALUE."
John PipkinJohn Pipkin
My fault. Should be  
CloseDate - DATEVALUE(CreatedDate) < 15

 
This was selected as the best answer
SF Buzz VutukuriSF Buzz Vutukuri
Thank you Thanks Regards Bhaswanthnaga vivek Vutukuri
John PipkinJohn Pipkin
No problem. If that answer solved your issue, please mark as "Best Answer". 

Thanks