🔠 How can I display data in different formats?
Dates, numbers, currencies, and percentages are displayed differently depending on the region. To make sure ChiliDocs® outputs them correctly, you need to add a format modifier to your placeholder.
All format options in ChiliDocs® start with:
[object.property(format:xyz)]
📊 General formatting
| Format | Control character | Result |
|
Date |
[deal.closedate(format:dd.MM.yyyy)] | 15.02.2025 |
| Currency (Euro) | [deal.amount(format:currency)] | €3,190.00 |
| Currency (USD) | [deal.amount(format:currency)] | $3,190.00 |
| Percentage | [deal.discount(format:%)] | 15% |
| Uppercase | [contact.lastname(format:upper)] | MUSTER |
| Lowercase | [contact.lastname(format:lower)] | muster |
| Phonenumber | [contact.phone(formatphone:prefix)] | +1 234-567-8901 |
|
Phonenumber |
[contact.phone(formatphone:noprefix)] | (234) 567-8901 |
|
Hide HTML Tags <p>, <h1>, <img> etc. |
[company.richtext(format:removehtml)]] |
This is a title. (instead of <h1>This is a title</h1>) |
⏰ Date & time formats
| Format | Control character | Result |
|
Standard |
[deal.closedate(format:dd.MM.yyyy)] | 15.02.2025 |
| Standard short | [deal.closedate(format:dd.MM.yy)] | 15.02.25 |
| MM.dd.yyyy | [deal.closedate(format:MM.dd.yyyy)] | 02.15.2025 |
| MM-dd-yyyy | [deal.closedate(format:MM-dd-yyyy)] | 02-15-2025 |
| MM/yyyy | [deal.closedate(format:MM/yyyy)] | 02/2025 |
| HH:mm:ss | [deal.closedate(format:HH:mm:ss)] | 12:05:30 |
| Time only | [deal.closedate(format:timeonly)] | 12:05 |
| Date only | [deal.closedate(format:dateonly)] | 15.02.2025 |
⚠️ Notes
- Be careful with uppercase vs lowercase when defining formats:
-
MM = month, mm = minutes
-
-
Currency automatically follows either the account default currency or the deal-specific currency (see article “How to display currency in the correct format”).
-
For rich text fields, you can strip out HTML tags using removehtml.