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