function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Kenney BrewKenney Brew 

Trailhead issue: The 'Day_of_the_Week__c' field does not exist on the Contact object.

 I am having issues validating the answer.  I used the formula from the help area, and the trail says that the answer is incorrect.  See my answer below.  Anus assitance is appreciated.

CASE(
  MOD( date - DATE( 1900, 1, 8 ), 7 ),
  0, "Monday",
  1, "Tuesday",
  2, "Wednesday",
  3, "Thursday",
  4, "Friday",
  5, "Saturday", 
  "Sunday"
)
William Christ NYWilliam Christ NY
Some have noted in the Success Community that this challenge may be tied to a specific time zone which may not match your actual time zone.  You may get different results depending on the time of day that you check it.  So if you noticed the challenge failed in the morning, try it again at night, or vice versa.  You can also check the time zone of your developer org to see if it is consistent with your location.  That may or may not make a difference in the results.
Amit Chaudhary 8Amit Chaudhary 8
Please check below post for same issue
1) https://developer.salesforce.com/forums/?id=906F0000000MIYiIAO
Please check above post for solution and issue detail.

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

or
https://developer.salesforce.com/forums/?id=906F0000000D9ytIAC 
CASE( 
MOD(TODAY() - DATE(1900, 1, 7), 7), 
1, 'Monday', 
2, 'Tuesday', 
3, 'Wednesday', 
4, 'Thursday', 
5, 'Friday', 
6, 'Saturday', 
'Sunday' 
)
Let us know if this will help you

Thanks
AMit Chaudhary

 
Kenney BrewKenney Brew
Thanks for pointing me in the right direction. The time zone change worked well.