> For the complete documentation index, see [llms.txt](https://altaisoft.gitbook.io/ysv/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://altaisoft.gitbook.io/ysv/language/date-and-time.md).

# Date & time

## date

```yaml
version: 1
columns:
  date:
    - input: "Transaction Date"
    - date: "%Y-%m-%d"
```

The argument to `date` is the format the date is expected to be in. Format is documented in [here](https://docs.rs/chrono/0.4.12/chrono/format/strftime/index.html#specifiers).

If the parsing fails, empty value is returned.

```yaml
version: 1
columns:
  date:
    - input: "Transaction Date"
    - date:
      - "%Y-%m-%d"
      - "%m/%d/%Y"
```

As shown above, you can specify multiple formats. System will try them one by one, until one of them fits. This helps to standardize datasets where date formats in one column may vary.