+ Start a Discussion
KoolABKoolAB 

Sending Email Alerts from Process Builder in Salesforce.com at a specified time say 9 AM CET

I have a business requirement to send email alerts using process builder at a specific time say 7 days after close date of Opportunity @ 9 AM CET
I can send email alerts after 7 days but i dont see any option to send email alert at a specified time of the day. Does any salesforce.com expert exist on this developer board who can answer my query
subbarao kalavalasubbarao kalavala
go setup>create>workflow>processbuilder
and then name it
and then add your object in which the fields are present save it
and now u will come to decision box ,label and keep condation and add immediate action or rime- dependent action
in time dependent action keep condation email aleart in that if you need at particular time you mention time format and date as below
use this formula instead of creteria

IF( OR( VALUE( MID( TEXT( date/time - TZoffset ), 12, 2 ) ) = 0, VALUE( MID( TEXT( date/time - TZoffset ), 12, 2 ) ) = 12 ), "12", TEXT( VALUE( MID( TEXT( date/time - TZoffset ), 12, 2 ) ) - IF( VALUE( MID( TEXT( date/time - TZoffset ), 12, 2 ) ) < 12, 0, 12 ) ) 11 Common Date Formulas ) & ":" & MID( TEXT( date/time - TZoffset ), 15, 2 ) & ":" & MID( TEXT( date/time - TZoffset ), 18, 2 ) & " " & IF( VALUE( MID( TEXT( date/time - TZoffset ), 12, 2 ) ) < 12, "AM", "PM" )