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@SiemensSF@Siemens 

Workflow Rules/Email Alert Criteria Question

Hello,
 
I am working to create a Workflow Rule that matches a few different criteria and have it send an email alert to a user if the criteria matches.  My question is, I need to be able to only send the email between Tuesdays and Thursdays.  Is there anyway that I can create criteria for that situation?
 
Thanks for any suggestions,
rpr2rpr2

You should be able to do this by including a check for the day of the week as part of your workflow rule formula.  Here's how you would determine the day of the week as a number (0 = Sunday, 1 = Monday, 2 = Tuesday, and so on). 

MOD(TODAY() - DATE(1900, 1, 7), 7)