Skip to main content
Skip table of contents

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

Click on the format you want to customize

Adjust the format settings as needed

image-20240129-062326.png

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

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 formatted 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.