Depending on the region/country, a different date format is common. In the ChiliDocs® Word template, this can be taken into account by adding a control character.
In HubSpot, we work with various date fields, e.g., for the closing date of a deal. The format defined for display in HubSpot is not provided via the API. To account for this, the field control character in the ChiliDocs Word template must be given a small addition:
[deal.closedate(format:dd-MM-yyyy)]
Available Date and Time Formats
-
Date (dd-MM-yyyy):
[deal.closedate(format:dd-MM-yyyy)]→ 31-12-2024 -
Date without time:
[deal.closedate(format:dateonly)]→ 31.12.2024 -
Only time:
[deal.closedate(format:timeonly)]→ 10:32 -
Date USA (MM.dd.yyyy):
[deal.closedate(format:MM.dd.yyyy)]→ 12.31.2024 -
Date Year/Month:
[deal.closedate(format:yyyy/MM)]→ 2024/12
Explanation of Placeholders
-
dd – Day as a two-digit number (01-31)
-
MM – Month as a two-digit number (01-12)
-
yyyy – Year in four-digit format (2025)
-
HH – Hour in 24-hour format (00-23)
-
mm – Minutes (00-59)
-
ss – Seconds (00-59)
Note: Pay attention to uppercase and lowercase characters when defining formats. For example, MM represents the month, whereas mm stands for minutes.
Supported Delimiters
Different delimiters can be used for date formats depending on the requirement:
-
Hyphen:
dd-MM-yyyy→ 31-12-2024 -
Dot:
dd.MM.yyyy→ 31.12.2024 -
Slash:
dd/MM/yyyy→ 31/12/2024
This allows the date format to be flexibly adjusted to meet specific requirements.