You need to sign in to do that
Don't have an account?

How to get Day of created date using formula field
Hi,
I want to find the day of paticular date e.g if my date is 28-jun-16 then my formula field should be written as thursday. How can i achieve this? please give me some suggestions.
I want to find the day of paticular date e.g if my date is 28-jun-16 then my formula field should be written as thursday. How can i achieve this? please give me some suggestions.
Can you try this...
CASE(
MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 6), 7),
0, "Sunday",
1, "Monday",
2, "Tuesday",
3, "Wednesday",
4, "Thursday",
5, "Friday",
6, "Saturday", "Error")
All Answers
Here is a formula that will return the text for what day of the week
The data type is TEXT
CASE(
MOD(CreateDate - DATE(2000, 1, 7), 7),
0, "Sunday",
1, "Monday",
2, "Tuesday",
3, "Wednesday",
4, "Thursday",
5, "Friday",
6, "Saturday", "Error")
For more information please refer to the below link
https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm
Hope this helps...
Kindly mark my solution as the best answer if it helps you.
Best Regards,
Nagendra.P
I tried this one. But it showing error value for all records
CASE( MOD( Date__c - DATE(1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,
"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday","Error")
Can you try this...
CASE(
MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 6), 7),
0, "Sunday",
1, "Monday",
2, "Tuesday",
3, "Wednesday",
4, "Thursday",
5, "Friday",
6, "Saturday", "Error")
Its working fine for me. Thank you so much.