You need to sign in to do that
Don't have an account?
neeru
How to display current month name
Hi All
my need is i want to create a formula field it displays current month name...is it possible to display current month name using formula field??
Thanks,
Jake
Use DATEVALUE to convert the CreateDate to a date from a datetime field.
CASE(
MONTH(DATEVALUE(Createddate)),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December",
"None")
All Answers
Hi,
Use the below:
CASE(MONTH(Createddate,
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December",
"None")
Thanx For reply JBabu
i am getting error like this
Error:Incorrect parameter type for function 'MONTH()'. Expected Date, received DateTime
Thanks,
Jake
Use DATEVALUE to convert the CreateDate to a date from a datetime field.
CASE(
MONTH(DATEVALUE(Createddate)),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December",
"None")
Thanx Joanc
Now its working fine..
Thanks,
Jake
This is the error message im receiving while using this formula.