You need to sign in to do that
Don't have an account?
Eric 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.)"
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.)"
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