Date Extract lets you isolate data from a date.
Add Date Extract to any node in your Dataflow. Select any node and use the Transform (+) button to open the list of options to select Join. You could work with the node in the Dataflow tab or use the Properties panel.
Use the first dropdown on the left to select a column in your data.
Note: The dropdown pre-filters your data to show on columns with Dates data.
Use the middle dropdown to select how you would like to parse your dates.
There are twelve Date Extract options as show below:
Use the right side dropdown to select how to display your extracted data. You may choose from the number or the string (text) data type.