Date Field Extractor (legacy)

Extracts the selected date fields from a date/time column and appends the values as integer columns. Available fields are year, quarter, month, day, day of week. If these values are not set in the date/time cell a missing value is added in the result table.

Options

Column containing dates
Select the input column containing the dates.
Year
Check if the year should be extracted and appended as an integer column. The name for this column can be specified.
Quarter
Check if the quarter as a number in [1,4] should be extracted and appended as an integer column. The name for this column can be specified.
Month
Check if the month should be extracted and appended as an extra column. Select whether the (English) name of the month should be appended to the output table (Text) or the number of the month (Number) in [1, 12]. The name for this column can be specified.
Day
Check if the day of month should be extracted and appended as an integer column. The name for this column can be specified.
Day of Week
Check if the day of week should be extracted and appended as an extra column. Select whether the (English) name of the day (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday) should be appended to the output table (Text) or the number of the day in the week (Number) in [1, 7] starting with Sunday. The name of this column can be specified.
Day of Year
Check if the day of year should be extracted and appended as an integer column. The name of this column can be specified.
Week of Year
Check if the week of year (the week number) should be extracted and appended as an integer column. The name of this column can be specified.

Input Ports

Icon
Table containing date/time cells.

Output Ports

Icon
Input table with extracted date fields appended

Popular Successors

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.