How Can I Tell the Day of the Week of a Date in Salesforce?

Formulas:

There isn’t a worked incapacity to do this for you, yet you can make sense of it by checking the days since a date you know. Here’s the idea: I realize that June 29, 1985, was a Saturday. In case I’m endeavoring to make sense of the day of the seven day stretch of July 9 of that year, I subtract the dates to (Pivotal Training) determine the number of days (10) and then use modular division to figure to remove all the multiples of 7. The remainder is the number of days after Saturday (1 = Sunday, 2 = Monday, etc.) and you can use that number in your logic:

MOD(DATEVALUE( Date_Field__c ) – DATE(1985,7,1),7)

Apex Code

You could do the same thing with time deltas, but you can also use the poorly documentedDateTime.format() function:

// Cast the Date variable into a DateTime

DateTime myDateTime = (DateTime) myDate;

String dayOfWeek = myDateTime.format(‘E’);

// dayOfWeek is Sun, Mon, Tue, etc.