You can generate a SubDate column from a database date column and a specified date function.

If the column is a date type, then subdate functions that include hours and minutes cannot be selected. The calculated new column will be text type. The second parameter of the WeekNum function is 0.

Add a SubDate Column

Follow the below steps to add a SubDate column to the entity.

1. From the Entities panel on the left, select an entity. In this example, we have selected the 'DimDate' entity.

2. Click the More button and then select the Add SubDate Column option under the Quickly Create section.

   
   

   
   

   
   

   Add SubDate Column dialog box is displayed.

   
   

3. Enter the Name of the new subdate column.

4. Select the columns of the current table from the Field dropdown list. It has only date or date-time type fields. When the field type is a date, time-related sub-dates are not displayed in the Sub Date dropdown list.

5. Select the option from the Sub Date dropdown list.

   
   

   The WAX expression will be generated automatically.

   
   

   
   

6. Click the Add button. The added subdate column will be displayed under the chosen entity in the Entities panel along with its other attributes.

   
   

   
   

   Note: You cannot edit the autogenerated WAX expression here, but you can copy it.

Edit a SubDate Column

Follow the below steps to edit a subdate column in an entity.

1. From the Entities panel, select the entity which contains the subdate column you want to modify.

2. Click the Edit button next to the chosen subdate column.

   
   

   
   

   Edit SubDate Column dialog box is displayed.

   
   

   
   

3. Update the existing details as per the requirement, and press the Save button.

Delete a SubDate Column

Follow the below steps to delete a subdate column from an entity.

1. From the Entities panel, select the entity which contains the subdate column you want to delete.

2. Click the Delete button next to the chosen subdate column.

   
   

   
   

   Delete SubDate Column dialog box is displayed.

   
   

   
   

3. In the Delete Calculated Column dialog box, click the Yes button to confirm.