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
vishal gupta 47vishal gupta 47 

Created Day of the Week

HI,

Does anyone know a formula to show the day of the week a lead was created (ie Monday, Tuesday, etc.)? Here i want to know if i setup a workflow when  a lead is created and not contacted in 24 hours. The problem lies in leads that are submitted over the weekend.

Any help would be greatly appreciated.
 
Best Answer chosen by vishal gupta 47
NagendraNagendra (Salesforce Developers) 
Hi Vishal,

Try the below code matching your requirement criteria.
  
​CASE( MOD( datevalue(createddate) - DATE(1900, 1, 7), 7),
0, "Saturday",
6, "Sunday", "Weekday")

Please mark it as best answer if it helps you.

Best Regards,
Nagendra.P

All Answers

NagendraNagendra (Salesforce Developers) 
Hi Vishal,

Try the below code matching your requirement criteria.
  
​CASE( MOD( datevalue(createddate) - DATE(1900, 1, 7), 7),
0, "Saturday",
6, "Sunday", "Weekday")

Please mark it as best answer if it helps you.

Best Regards,
Nagendra.P
This was selected as the best answer
vishal gupta 47vishal gupta 47
Thanks it worked for me.