You need to sign in to do that
Don't have an account?
bhanu_prakash
weekend or weekday calcuate
I have created custom field on lead object with
Forumla return type :text
Using below formula
CASE (MOD (TODAY () - DATE (1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday”, “Error",NULL)
But issue is iam getting only TUESDAY as answer . please let me know where Iam wrong .
Thanks in Advance.
Forumla return type :text
Using below formula
CASE (MOD (TODAY () - DATE (1900, 1, 7), 7), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3,"Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday”, “Error",NULL)
But issue is iam getting only TUESDAY as answer . please let me know where Iam wrong .
Thanks in Advance.
We can't use fields in default value formula.Rather modify actual formula defination like this.
I Tried it it worked.
Let us know if its helpful.
If it's helpful mark it as best answer.
Thanks.
All Answers
If I understood your requirement correctly the formula looks like this. Please let me know if its useful.
If it's helpful mark it as best answer.
Thanks.
Thank for your update. I need to find out lead created day is weekday or weekend but it is showing today's day :(
How can i change Today () into lead created date ?
I cannot understand .Please help me
try this if you want to display weekdate or weekend
Try this formula if you want to display day of the week.
Let us know if its helpful.
If it's helpful mark it as best answer.
Thanks.
We can't use fields in default value formula.Rather modify actual formula defination like this.
I Tried it it worked.
Let us know if its helpful.
If it's helpful mark it as best answer.
Thanks.