You can customize how dates and timestamps appear in your Email and PDF templates by applying modifiers to your date variables (such as {{create_date}} or {{order_created}}).
There are three primary formatting options available:
Date Only (|date): Applies your system's default regional format:
EU: DD/MM/YYYY
US: MM/DD/YYYY
HTML:
{{create_date|date}}
Long Date (|longdate): Displays the full date in an expanded text format (e.g., 1 Jan 2025):
HTML:
{{create_date|longdate}}
Time Only (|time): Displays the timestamp only in standard 24-hour format (e.g., 14:30:00):
HTML:
{{create_date|time}}
By default, standard date variables dynamically adopt the date format selected in your platform localization settings (Settings > Localisation):
EU Regional Format:
DD/MM/YYYY(e.g.,28/02/2025)US Regional Format:
MM/DD/YYYY(e.g.,02/28/2025)
Variable Formatting Modifiers
You can apply explicit modifiers to date variables in HTML or PDF code to force specific representations:
In Email Templates | Variables Available for Formatting |
Order Created At (Datetime) | {{order_created}} |
Create Date | {{create_date}} |
Valid Until (Quote validity) | {{due_date}} |
Delivery Date | {{delivery_date}} |
Shipping Deadline | {{shipping_deadline}} |
Quote Creation Date | {{quote_created_at}} |
Production Deadline | {{deadline}} |
Quote Created | {{quote_created_at}} |
Actual Part Shipping Date (Parcels) | {{actual_part_shipping_date}} |
Actual Item Shipping Date (Parcels) | {{actual_item_shipping_date}} |
Actual Parcel Shipping Date (Parcels) | {{actual_parcel_shipping_date}} |
Invoice Date9 (Invoice module) | {{invoice_date}} |
In PDF Templates | Variables Available for Formatting |
Order Created At (Datetime) | {{order_created}} |
Ticket Create Date | {{create_date}} |
Valid Until (Quote validity) | {{due_date}} |
Delivery Date | {{delivery_date}} |
Shipping Deadline | {{shipping_deadline}} |
Quote Creation Date | {{quote_created_at}} |
Time to Ship (Production module) | {{time_to_ship}} |
Production Deadline | {{deadline}} |
Actual Part Shipping Date (Parcels) | {{actual_part_shipping_date}} |
Actual Item Shipping Date (Parcels) | {{actual_item_shipping_date}} |
Actual Parcel Shipping Date (Parcels) | {{actual_parcel_shipping_date}} |
Finance Date (Invoice module) | {{finance_date}} |
Finance Terms (Invoice module) | {{finance_terms}} |
Finance Due Date (Invoice module) | {{finance_due_date}} |
Timestamp | {{timestamp}} |
Select Date Formatting
There are 2 places in the Management Console where the date formatting can be selected:
Settings -> Localisation
Settings -> Users -> Edit User
Note: The User's Time Zone settings take precedence over the platform's localization settings if changed!
Emails:
When an email is triggered via a Workflow rule, the date format is taken from the Localisation page.
When the “New Order“ email is automatically sent after the order is created, the format is taken from the User's details.
Quote emails are also triggered with the date format from the User's details.
PDFs:
For a PDF printed from the Order view, the date formatting is taken from the Localisation page.
For a PDF printed from the Invoice module, the date formatting is taken from the Localisation page.