We have users from different locations using Salesforce and the date format (much debated on salesforce) displays the data based on the time zone in the numeric format ignoring the order or month and date, i.e. irrespective of dd/mm/yyyy or mm/dd/yyyy. The dates are extremely in reports and dashboards to keep a track of the opportunity won.
The support I need is to find a way (an apt formula) that I can change the numeric date format to the text date format.
i.e. 1/3/2019 to say, (text date format) March 1, 2019, or Mar-01-2019
Looking forward to learn about the same.
Hi Shivam, CASE(MONTH(Date_1__c),
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(Date_1__c))
+ ", " + TEXT(YEAR(Date_1__c))
This will help you!
Thanks!
