Manage Date Rules

You can use the Date Rules workspace 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.

Create Date Rules

You can add date rules to calculate relative dates.

To create date rules:

1. In the Setup workspace, in the left navigation, click Date Rules.
   You see the Date Rules workspace with list of available date rules.
2. Click Create New.
   You see the New Date Rule dialog box.
3. Enter Name for the field.
4. Optionally, enter a Description for the date rule.
5. Under Start Date, select a Type from the drop-down list.
6. Select the Offset by by entering the number and then selecting the frequency. Click Using Business Calendar to use the business calendar to determine the dates.
7. Select the Adjust to from the drop-down list. Click Using Business Calendar to use the business calendar to determine the dates.
8. Enter Additional Offset by entering the number and then selecting the frequency. Click Using Business Calendar to use the business calendar to determine the dates.

9. Under End Date, select a Type from the drop-down list and then click on the calendar to select a date. Options include:
   –  Fixed
   –  Calculate
   –  Fund Inception Date
   –  Fund Fiscal Year to Date
   –  Fund Fiscal Quarter to Date (Common Date)
   –  Fund Fiscal Year to Date (Common Date)
   –  Fund Fiscal Quarter to Date (Prior Year)
   –  Fund Fiscal Year to Date (Prior Year)

   Note

   If you select the Fixed option, you only need to enter the Start Date and then can enter the End Date. If you select the Calculate option, you need to enter the Offset parameters.

10. Select the Offset by by entering the number and then selecting the frequency. Click Using Business Calendar to use the business calendar to determine the dates.

    Note

    The Offset By setting allows you to adjust the start date of a process to run for a certain date in past or in the future. For example, if today if January 1st, and you want to create a data rule to rule to run a report fifteen days prior (December 16th), then you need to set the offset value as -15 and offset the data type as days. Entering a positive number in the Offset field will increase the input date while negative values will decrease the date.

11. Select the Adjust to from the drop-down list. Click Using Business Calendar to use the business calendar to determine the dates. Options include:
    –  Week Start
    –  Week End
    –  Month Start
    –  Month End
    –  Calendar Year Start
    –  Calendar Year End
    –  Quarter Begin
    –  Quarter End
12. Enter Additional Offset by entering the number and then selecting the frequency. Click Using Business Calendar to use the business calendar to determine the dates. Options include:
    –  Day(s)
    –  Week(s)
    –  Months(s)
    –  Quarter(s)
    –  Year(s)
13. To add a Single Date, select either Start Date or End date.
14. Select a Business Calendar Source from the drop-down list.
15. Select a Time Zone from the drop-down list.
16. Optionally, you can click Test Now to test the date rule or click the Test when saving checkbox to test when saving your changes.
17. Click Save.
    The new rule is added to 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. In the Setup workspace, in the left navigation, click Date Rules.
   You see the Date Rules workspace with the list of available date rules.
2. Select the date rule you want to view/edit and then 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.

Delete Date Rules

You can delete date rules from the list of available date rules in the workspace. 

To delete date rules:

1. In the Setup workspace, in the left navigation, click Date Rules
   You see the Date Rules workspace with the list of available Date Rules.
2. Select the date rule you want to delete and then click Delete.
   You see a confirmation box asking you to verify your selection.
3. Click Ok.
   The date rule is deleted from the system.

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/2018 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/2017 and then blocks all data older than 11/27/2017 from the 1/1/2018 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.