Apex Code Development You need to sign in to do that
Don't have an account?
Michael Kelly trailhead advanced formula
unit 3 creating a custom formula filed that calculates the day of the week.
I think my formula is good, and it brings back Monday as teh day of the week, but when I validate in trailhead it says it is not returning the correct day. my formula is here CASE( MOD( TODAY() - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,
"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")
I think my formula is good, and it brings back Monday as teh day of the week, but when I validate in trailhead it says it is not returning the correct day. my formula is here CASE( MOD( TODAY() - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,
"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")
1) https://developer.salesforce.com/forums/?id=906F0000000B0VyIAK
2) http://salesforce.stackexchange.com/questions/103847/formula-that-returns-the-current-day-of-the-week