Defining the Dates

Now you need to change the storage type of the DATE_ field to Date format.

  1. Attach a Filler node to the Filter node.
  2. Open the Filler node and click the field selector button.
  3. Select DATE_ to add it to Fill in fields.
  4. Set the Replace condition to Always.
  5. Set the value of Replace with to to_date(DATE_).
    Figure 1. Setting the date storage type
    Setting the date storage type

    Change the default date format to match the format of the Date field. This is necessary for the conversion of the Date field to work as expected.

  6. On the menu, choose Tools > Stream Properties > Options to display the Stream Options dialog box.
  7. Select the Date/Time pane and set the default Date format to MON YYYY .
Figure 2. Setting the date format
Setting the date format

Next