Menu

Format date and time

By default, data format will follow the end-user's default locale or from their personal setting in Salesforce. You can change the format using throughout the document by editing the Default Data Formatter in template Settings.

In Settings tab -> Salesforce Data -> Default Data Formatter

Click Modify button next to Date or Date Time formatter you want to customize

Click the Search button in Pattern attribute

Using available pattern

In the Pattern Editor, select the pattern you want to use

Click Test to see the example outcome

Click OK

Create your own pattern

You can create your own patter using the symbols in the following table

Type a new pattern in the Value 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.

Comments

0 comments