Settings and activity
-
10 votes
Tom Ellis shared this idea ·
-
72 votes
Tom Ellis supported this idea ·
-
67 votes
Tom Ellis supported this idea ·
-
351 votes
Tom Ellis supported this idea ·
-
374 votes
Tom Ellis supported this idea ·
-
281 votes
An error occurred while saving the comment Tom Ellis supported this idea ·
-
3 votes
Tom Ellis shared this idea ·
-
27 votes
Tom Ellis supported this idea ·
-
1 vote
-
192 votes
-
6 votes
This is so needed! I am having to create extra fields in the CRM to produce text versions of the date and merge them into the PandaDoc templates.
In case anyone should need it, here is an example Salesforce formula that takes a custom date/time field and converts it from"23/11/2021" format to "23rd November 2021" - You can substitute Date_Today__c for "CreatedDate" or even "Now()" for instance.
(TEXT(DAY(Date_Today__c)))
+(CASE(DAY(Date_Today__c),
1, "st",
2, "nd",
3, "rd",
21, "st",
22, "nd",
23, "rd",
31, "st",
"th"
))
+" "+
CASE(
MONTH(Date_Today__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(YEAR(Date_Today__c))