Defining the As of Date Column

When creating a section, you can define an As of date.

*  To define the As of date column:

  1. In Interactive Reporting Studio:

    1. On the Request line of a query, create and name a computed item; for example, Query Date.

      1. Right-click on the Request line, and select Add Computed Item.

        Modify Item is displayed.

      2. Enter the name of the item as Query Date.

      3. In Definition, set the custom SQL value for the item; for example, now().

      4. Click OK to close Modify Item.

    2. Double-click the item on the Request line; for example, now(Query Date), to display Item Properties.

    3. Click Options to display the Datatype drop-down list.

    4. Ensure that the column data type is Date, DateTime, or TimeStamp.

    5. In Item Properties, click OK to return to the section.

  2. Click File, then Save to save the As of date.

    See Step 7: Configure Properties, to set the properties of the As of date column.