Formatting tips
This is a list of all types of data formatting, which can be used for #format_value.
Date/ time format strings
Format | Explanation |
|---|---|
d | The day of the month, from 1 through 31. |
dd | The day of the month, from 01 through 31. |
ddd | The abbreviated name of the day of the week. |
dddd | The full name of the day of the week. |
M | The month, from 1 through 12. |
MM | The month, from 01 through 12. |
MMM | The abbreviated name of the month. |
MMMM | The full name of the month. |
yy | The year, from 00 to 99. |
yyy | The year, with a minimum of three digits. |
yyyy | The year as a four-digit number. |
h | The hour, using a 12-hour clock from 1 to 12. |
hh | The hour, using a 12-hour clock from 01 to 12. |
H | The hour, using a 24-hour clock from 0 to 23. |
HH | The hour, using a 24-hour clock from 00 to 23. |
m | The minute, from 0 through 59. |
mm | The minute, from 00 through 59. |
s | The second, from 0 through 59. |
ss | The second, from 00 through 59. |
t | The first character of the AM/PM designator. |
tt | The AM/PM designator. |
: | The time separator. |
/ | The date separator. |
"string" | Literal string delimiter. |
Examples
<div>
{{format_value History.FirstScreenedOn 'd MMMM yyyy' }}
</div>
<div>
{{format_value Metadata.CreatedOn 'd MMMM yyyy "at" HH:mm' }}
</div>Numeric format strings
Format | Explanation |
|---|---|
C | Currency |
D | Decimal (integer digits with optional negative sign) |
N | Number (integral and decimal digits, group separators, and a decimal separator with optional negative sign) |
P | Percent (number multiplied by 100 and displayed with a percent symbol) |
Tip: You can add a precision specifier, eg. C2 or D5
Example
<div>
{{format_value Finance.TotalBudget 'C2' }}
</div>