Complete the following steps to extract components from a date/time column.
Choose one of the following:
Data > Date/Time > Extract to Numeric
Data > Date/Time > Extract to Text
In Extract from date/time
column, enter the column.
In Store numeric column
in or Store text column
in, enter a column number (for example, C2) or a column name. If a column name has more than one word, enclose the name in single quotation marks.
From Specify at least one
component to extract from date/time, select one or more components, such as day, quarter, or hundredth of a second, that you want to extract.
