🔠 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
with no prefix

[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.