formatTimePeriod Function | Vantage CX - formatTimePeriod - Vantage Customer Experience

Formats each time-based value into a numeric representation of the specified time interval. The formatTimePeriod function is used only within the context of a filter.

Example 1:

count(
                filter(
                                get("Account.dates"),
                                "maturity",
                               formatTimePeriod("day"),
                               equalTo(15)
                )
) > 3	

This example returns true if there are more than three maturity dates that occur on the 15th day of the month.

Example 2:

count(
                filter(
                                get("Account.dates"),
                                "maturity",
                               formatTimePeriod("month"),
                               equalTo(12)
                )
) > 3

This example returns true if there are more than three maturity dates in December (the 12th month).