Date & time

date

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.

If the parsing fails, empty value is returned.

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.