Changing the date format in emails and documents

Modified on: Mon, 13 Jan, 2025 at 1:38 PM

Print

Date formats

By default, the date format used in the date placeholders is the following (commonly known as US format) - MM/DD/YY. In order to set a different format for dates, you will need to slightly edit the placeholder. To illustrate this, we will use the placeholder that pulls the arrival date of a booking in an email created through the Guest Mailer.

Note: You can change the date format following the instructions below in:

  • any email you create in the Guest Mailer;
  • custom Booking Enquiry template
  • custom Folio template
  • custom Folio Email template
  • custom Event documents
  • custom Registration card template

The placeholder for the arrival date looks like this by default - {{booking.arrival | date: "%D"}} - this will generate the date in US format - MM/DD/YY

To change the format, edit the part after 'date:'. 

Here are the available options:

  • {{booking.arrival | date: "%m"}} = MM
  • {{booking.arrival | date: "%d"}} = DD
  • {{booking.arrival | date: "%D"}} = MM/DD/YY
  • {{booking.arrival | date: "%y"}} = YY
  • {{booking.arrival | date: "%Y"}} = YYYY
  • {{booking.arrival | date: "%x"}} = MM/DD/YY
  • {{booking.arrival | date: "%X"}} = HH:MM:SS
  • {{booking.arrival | date: "%a"}} = Sun (day of week short)
  • {{booking.arrival | date: "%A"}} = Sunday (day of week full)
  • {{booking.arrival | date: "%b"}} = Aug (month of year short)
  • {{booking.arrival | date: "%B"}} = August (month of year full)
  • {{booking.arrival | date: "%c"}} = Sun Nov 6 00:00:00 2016
  • {{booking.arrival | date: "%F"}} = YYYY-MM-DD

You can use a combination of the options to get the needed format. 

For example:
  • If you want the format to be DD/MM/YYYY, the placeholder should be {{booking.arrival | date: "%d/%m/%Y"}}.
  • If you want the day of the week to be in front, the placeholder should be {{booking.arrival | date: "%A %d/%m/%Y"}} = Sunday 18/08/2024.

Follow the same procedure to change the format for any other date placeholder - e.g. departure date, event arrival/departure date, etc.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

On this page