Tokens representing dates and numbers can be formatted using the FORMAT_DATETIME and FORMAT_NUMBER functions.
The FORMAT_DATETIME function is used to configure the format of date and time values inserted into messages, by specifying the date and time components that are returned. Standard date and time components can be used, such as:
- MM: Numerical month (for example, 01-12)
- MMM: Short name of month (for example, Jan – Dec)
- d: Numerical date (for example, 1-31)
- dd: Two-digit numerical date (for example, 01-31)
- ddd: Short name of weekdays (for example, Sun – Sat)
- dddd: Full name of weekdays (for example, Sunday – Saturday)
- yy: Two-digit year (for example, 13, 14)
- yyyy: Four-digit year (for example, 2013, 2014)
- h: Hours (for example, 1-12)
- hh: Two-digit hours (for example, 01-12)
- H: 24-hour clock hours (for example, 1-23)
- HH: Two-digit 24-hour clock hours (for example, 01-23)
- mm: Minutes
- ss: Seconds
- tt: AM/PM indicator
For example:
<<FORMAT_DATETIME(TerminationDate,'ddd MMM-dd-yyyy')>>
The example above returns the employee’s termination date in the configured format (for example, Mon Apr-01-2013).
The FORMAT_NUMBER function is used to configure the decimal precision of values inserted into messages. For example:
<<FORMAT_NUMBER(BaseRate,'#.##')>>
The example above returns the employee’s base rate to two decimal places (for example, $8.35).