4.3.7 Creating a Date Range Column
A date range column groups dates into a fixed set of date bins. You can create a range column for any date column in a Data Table.
To create a range column, follow these steps:
1. Right-click the header of the column for which you want to create a range column, and select the 'New Range Column' option from the context menu. This opens the 'Date Range Name' dialog box.
2. Enter a name for the new column in the 'Date Range Name' dialog box, and click 'OK'. This opens the 'Date Range Option' dialog box.

3. Select the desired partitioning (year, month, quarter, etc.), and click the 'OK' button to close the dialog box.
See Creating a Numeric Range Column for doing a similar partitioning on numeric columns.
Available Date Ranges
There are five date ranges available for the date range column:
• 'Year': A number in the range 0000-9999
• 'Quarter': A number in the range 1-4
• 'Month': A number in the range 0-11
• 'Day of Week': A number in the range 1-7
• 'Day of Month': A number in the range 1-31
| << 4.3.6 Creating a Numeric Range Column | © 1996-2013 InetSoft Technology Corporation (v11.4) | 4.4 Editing a Table Column >> |