# FORMAT\_DATE

### Description

`FORMAT_DATE` formats a given date, from either an information or a text in [ISO8601 format](https://docs.atfinity.io/rule-language/operators/date-operators/..#iso8601-format), into the specified format. There might be two documents that ask for a different date format, e.g. `28.02.2022` vs. `02-28-2022`. The given format can contain the following options:

| Option | Description                               |
| ------ | ----------------------------------------- |
| `D`    | Days without leading zero, e.g. 7 or 13   |
| `DD`   | Days with leading zero, e.g. 07 or 13     |
| `M`    | Months without leading zero, e.g. 2 or 11 |
| `MM`   | Months with leading zero, e.g. 02 or 11   |
| `YYYY` | The year, e.g. 1987 or 2021               |

### Example: German Format

```
FORMAT_DATE('2022-02-28', 'DD.MM.YYYY')
```

This returns `28.02.2022`.

### Example: US Format

```
FORMAT_DATE('2022-02-28', 'MM-DD-YYYY')
```

This returns `02-28-2022`.