---
title: Formatting tips
slug: formatting-tips
icon: {"faIcon":"fa-brands fa-mixcloud"}
createdAt: 2022-10-05T08:32:12.000Z
---

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

```html
<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<br /> decimal separator with optional negative sign) |
| P      | Percent (number multiplied by 100 and displayed with <br />a percent symbol)                                      |

:::hint{type="info"}
Tip: You can add a precision specifier, eg. C2 or D5
:::

### Example

```html
<div>
    {{format_value Finance.TotalBudget 'C2' }}
</div>
```

