Extract from date/time

Complete the following steps to extract components from a date/time column.

  1. Choose one of the following:
    • Data > Date/Time > Extract to Numeric
    • Data > Date/Time > Extract to Text
  2. In Extract from date/time column, enter the column.
  3. 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.
  4. 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.