Using Date Rules

The dynamic mutual fund performance fields allow the use of date rules to define the performance period. This allows you to take advantage of date rule functionality and allow reports to calculate returns for the periods specified by the date rule. For example, you can calculate a quarterly return as of last quarter. A report run for 12/31 can give you a quarterly return for both 9/30-12/31 as well as 6/30 – 9/30.

Dynamic mutual fund fields have certain requirements for begin and end dates that are passed to it. Both the dynamic mutual fields and the date rules themselves include logic for going back one day. Therefore, a date rule that is used for dynamic mutual fund performance must always add back a day (so that you do not look back twice).