Get year, month, day from a string that represents a date

QuickTable support for various operations on date data. In this example, you want to get year, month, day from a date column.

Click "Dates & Times" in the toolbar, you'll see data manipulations for all date types supported by QuickTable:

Click "Extract value" and you'll see something you can get from a string that represents a date.

Click "Year" and select "Order Date", click "Preview", you will see the result as follows:

You can extract different content by changing the Unit, for example, Month, Day.