✨
ysv
  • ysv
  • Installation
  • Usage
  • Configuration format
  • Configuration Language
    • Basics
    • input
    • Constants
    • String transformations
    • Date & time
  • Technology Choices
Powered by GitBook
On this page

Was this helpful?

  1. Configuration Language

Date & time

PreviousString transformationsNextTechnology Choices

Last updated 4 years ago

Was this helpful?

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 .

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.

here