You need to sign in to do that
Don't have an account?
Timezone Error in Trailhead Challenge
There is a timezone issue with the challenge for "Using Date and Date/Time Formulas" in the advanced forumlas module. I used the following formula to finally get past the challange. This formula is clearly wrong as the "+1" should not be needed.
CASE(MOD((Today()+1)- DATE(1900,1,7), 7), 0, 'Sunday', 1, 'Monday',2,'Tuesday',3,'Wednesday',4,'Thursday',5,'Friday',6,'Saturday','error')
CASE(MOD((Today()+1)- DATE(1900,1,7), 7), 0, 'Sunday', 1, 'Monday',2,'Tuesday',3,'Wednesday',4,'Thursday',5,'Friday',6,'Saturday','error')
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)