Anyone know how I can return the month name in this formula so it looks lke this - April 27, 2019:
TEXT(DAY(PRIORVALUE(CloseDate))) & '/' & TEXT(MONTH(PRIORVALUE(CloseDate))) & '/' & TEXT(YEAR(PRIORVALUE(CloseDate)))
Thank You!
John
4 answers
Give this a try
CASE(MONTH(PRIORVALUE(CloseDate)),
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") + ' ' +
TEXT(DAY(PRIORVALUE(CloseDate))) + ', ' +
TEXT(YEAR(PRIORVALUE(CloseDate)))
