The CalendarReferenceGen Generator adds or subtracts a specified amount of time from a referenced calendar generator and displays the resulting date


The following parameters may be configured for the CalendarReferenceGen Generator. Items with an asterisk* are required.   

  • reference* – Defines the Attribute to reference. The value of the referenced Attribute should be a date string.

  • jumpBy – Defines the measure of distance to jump:
    • Year
    • Month
    • Day
    • Hour
    • Minute
    • Second
    • Millisecond

  • jumpAmount* - Defines how far positive or negative a measure to jump.

  • format* - Defines the format of the date. The format should be the format of the date string being referenced. Refer to this link for the different date and time format:

Example 1

In this example, the referenced calendar date (ref_calendar_dt) must be 15 days after ref_calendar_date. The parameters would be configured as below:

  • reference = #{self.gen1}
  • jumpBy = Day
  • jumpAmount =15
  • format = yyyy-MM-dd

This example includes 2 linked Generators: FlexibleDateRangeGen and CalendarReferenceGen. The FlexibleDateRangeGen is referenced by the reference Parameter.

The FlexibleDateRangeGen Generator configuration is shown below: 

Note: To learn more about linking Generators, please see the following knowledge base section: Linked Generators.

Sample Output

As shown in the sample output below, each date is 15 days later than the referenced calendar date: