In Salesforce Trailhead there is one Challenge available. Please find the challenge description below
To complete this challenge, use some of the strategies and function you learned in this unit to return the day of the week as a text string.
- The formula should be on the Contact object
- The formula should be of return type Text
- The formula should be named 'Day of the Week' with the resulting API
- The formula should return the day of the week as a string—”Monday,” “Tuesday,” and so on
I tried the following formula
CASE(MOD( TODAY() - DATE(1900, 1, 6), 7), 0, "Saturday", 1, "Sunday", 2,"Monday", 3, "Tuesday", 4, "Wednesday", 5, "Thursday", 6,"Friday","")
It returns 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.)
What is the problem ?