function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Eric HuynhEric Huynh 

Trailhead - Getting day of the week

I am doing a trailhead advance admin exercise on getting the day of the week.
However, the system does not believe it is the correct formula.
Can someone please help?

Here's what I have:

CASE( MOD(TODAY() - DATE(1900, 1, 7), 7),
1, "Monday",
2, "Tuesday",
3,"Wednesday",
4, "Thursday",
5, "Friday",
6, "Saturday",
0, "Sunday",
"")

However, the system gave me the following error:
"Challenge Not yet complete... here's what's wrong: 
The 'Day_of_the_Week__c' is not reporting the correct day of the week (Monday, Tuesday, etc.)"
Joseph Kubon (he/him/his)Joseph Kubon (he/him/his)
Hello,

These 2 posts discuss the same issue.  it deals with the timezone alignment of your location, their system and GMT.

https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009Nek&fId=0D53000002QsY2p (https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009Nek&fId=0D53000002QsY2p)

http://salesforce.stackexchange.com/questions/103847/formula-that-returns-the-current-day-of-the-week

I am waiting to see how it will validate for me in the AM.

Good luck,
Joseph