Sorry, we didn't find any relevant articles for you.

Send us your queries using the form below and we will get back to you with a solution.

How do I use the CalendarReferenceGen Generator?

Description

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

Parameters

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: https://genrocket.freshdesk.com/solution/articles/19000087967.

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: