Extract date components from a date/time column and store in them a text column

You can extract specified date or time components and store them in a text column. This extraction is useful when you want to use a date component, such as the fiscal quarter, as a categorical variable. For example, a sales manager wants to create a bar chart where each bar shows quarterly sales. The sales manager extracts the quarter and year components of a date/time column and puts them in a text column.

C1-D
Date
04/29/2014 12:52:34
08/09/2015 04:32:10
12/04/2014 06:52:03
10/04/2013 11:22:33
Original column
C2-T
Quarter
Q22014
Q32015
Q42014
Q42013
Result column
  1. Choose Data > Date/Time > Extract to Text.
  2. In Extract from date/time column, enter Date.
  3. In Store text column in, enter Quarter.
  4. Select Quarter and Year.
  5. Click OK.
Note

When you use a text column to create a graph (or table), the text categories are in alphabetical order by default. To change the value order, right-click the column and choose Column > Value Order.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy