Settings and activity
10 results found
-
28 votes
Tom Ellis shared this idea ·
-
89 votes
Tom Ellis supported this idea ·
-
75 votes
Tom Ellis supported this idea ·
-
430 votes
Tom Ellis supported this idea ·
-
574 votes
Tom Ellis supported this idea ·
-
333 votes
An error occurred while saving the comment Tom Ellis supported this idea ·
-
6 votes
Tom Ellis shared this idea ·
-
38 votes
Tom Ellis supported this idea ·
-
1 vote
-
232 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))