All Collections
CRM Tools
Workflows and Touchpoints
Advanced: Custom Date Formats in Merge Tags
Advanced: Custom Date Formats in Merge Tags

Create custom date formats using standard syntaxes

Laura Montgomery-Hurrell avatar
Written by Laura Montgomery-Hurrell
Updated over a week ago

By default the CRM displays dates in merge tags as Tuesday 1 October 2019.

However, we recognise that this might not suit everyone's style, so advanced users can change the date format to suit your establishment's branding better.

To set the format in Touchpoints, use the merge fields pop-up to copy in the date field you want to use, such as Invite Event Date, then append |format=your format.

For example in POD:

[xxxPodInvite.event_date|format=l jS \of F Yxxx] will print as Tuesday 1st of October 2019

To set the format in a Campaign, select the date field you want to use from the merge field pop-up, then select one of the preset formats. You can then edit this using the same formats as below.

This formatting works in both the body of an email or SMS and the subject line of an email.

Please note:

Changing the capitalisation of your syntax will change the outcome of your format.

Characters such as . , - : / can be used in short-form dates and times. However, \ must only be used to escape letters that you don't want used as part of the syntax.

Some suggestions of commonly used formats are:

Format required              | Syntax to use
-----------------------------|--------------
Tuesday 1 October 2019 | l j F Y
Tue 1 Oct 2019 | D j M Y
Tuesday 1st of October 2019 | l jS \of F Y
Tuesday 1st October 2019 | l jS F Y
01.05.2019 | d.m.Y
1/5/19 | j/n/y
23:01h | H:i\h
11:01 pm | g:i a

The below table explains the different parts of the syntax:

Did this answer your question?