Format Date and Time
By default, data format will follow the end-user's default locale or from their personal setting in Salesforce. The format can be changed throughout the document by editing the Default Data Formatter in template Settings.
In the Document tab -> Formats
![image-20240129-062245.png](../__attachments/178061313/image-20240129-062245.png?inst-v=5205e5d1-dc16-46d7-af02-1258d99cc136)
Click on the format you want to customize
Adjust the format settings as needed
![image-20240129-062326.png](../__attachments/178061313/image-20240129-062326.png?inst-v=5205e5d1-dc16-46d7-af02-1258d99cc136)
Using available pattern
In the Pattern Editor, select the pattern you want to use
Click Test to see the example outcome
Click OK
![image-20240129-062406.png](../__attachments/178061313/image-20240129-062406.png?inst-v=5205e5d1-dc16-46d7-af02-1258d99cc136)
Create your own pattern
You can create your own patter using the symbols in the following table
Type a new pattern in the Edit pattern and click Test or OK
Symbol | Meaning | Example Outcome |
---|---|---|
d or dd | day of the month | 2 or 02 |
M or MM | month of the year | 7 or 07 |
MMM | month of the year (Abbreviated text) | Jul |
MMMM | month of the year (Full text) | July |
yy | year | 17 |
yyyy | year | 2017 |
E | day of the week (Abbreviated text) | SUN |
EEEE | day of the week (Full text) | Sunday |
a | am/pm marker | PM |
HH | hour in day (0-23) | 00 |
hh | hour in am/pm (1-12) | 12 |
kk | hour in day (1-24) | 24 |
mm | minute in hour | 40 |
ss | second in minute | 45 |
zzz | time zone (Abbreviated text) | PST |
zzzz | time zone (Full text) | Pacific Standard Time |
' | escape for text | (none) |
Example patterns for Date and Date Time formatters
Pattern | Example outcome |
---|---|
d MMMM yyyy | 2 July 2017 |
dd-MMM-yyyy | 02-Jul-2017 |
EEEE, d MMMM yyyy | Sunday, 2 July 2017 |
E, dd-MM-yy | SUN, 02-07-17 |
HH:mm | 17:48 |
hh:mm a | 05:48 PM |
MMMM d 'at' hh:mm a | July 2 at 05:48 PM |
You will see the final example how data will be format by default in the document. If you want to format a specific field differently than the rest of the document, you can create a Custom Data Formatter and apply that into the template.