Manage Date Rules

You can use the Setup workspace in Reference Data Center to add, view, and edit date rules. Date rules determine the date (or date range) that filters data used for an associated process. For example, date rules are used to calculate relative dates, that is, dates in relation to the current cycle effective date. You can assign a date rule to block stale vendor data from use when you define the data strategies.

Add Date Rules

You can add date rules to calculate relative dates.

To add date rules:

  1. From the Setup workspace, click Date Rules in left navigation.
    You see the Date Rules workspace with list of available date rules.
  2. Click New.
    You see the New Date Rule dialog box.
  3. Enter Name for the field.
  4. Enter Comments/Remarks for the field.
  5. Click the 3. How do you want your start date? drop down, select calculate, and complete the start date information.
  6. Click the 4. How do you want your end date? drop down, select calculate, and complete the end date information.
  7. Set the 5. What date do you wish use in functions where a single date is required? field to Start date or End date.
  8. Click the 6. Which Source do you want to use for the business Calendar? drop down and select the data source you wish to use for your business calendar. Default is EAGLE PACE.
  9. Click OK.
    You see a message that the date rule was successfully saved and the Date Rules window refreshes the list of available date rules.

View / Edit Date Rules

You can view and edit date rules that calculate relative dates.

To view / edit date rules:

  1. From the Setup workspace, click Date Rules in left navigation.
    You see the Date Rules workspace with the list of available date rules.
  2. Select the date rule you wish to view/edit and click Edit on the toolbar.
    You see the Edit Date Rule dialog box.
  3. Review the information, make the appropriate changes, and click OK.
    You see the Date Rules window refresh with the list of available date rules.

Date Rule Example

You can use date rules for processing data strategies for time-sensitive reference data types such as Schedules. You can also use date rules to control when vendor data is consider too stale for composite use.

For example, assume that you are processing composited securities for an effective date of 1/1/2013 and wish to exclude vendor data that is more than 35 days old. You can assign a date rule to the data strategy that calculates the relative date 11/27/2012 and then blocks all data older than 11/27/2012 from the 1/1/2013 compositing process. In effect, only the most recent vendor data within the calculated 35-day window is composited and all older vendor data is ignored.