1.0 - formatTimePeriod - Vantage Customer Experience

Vantage Customer Experience User Guide

prodname
Vantage Customer Experience
vrm_release
1.0
category
User Guide
featnum
B035-3800-099K

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.

See the time function for the supported time periods.

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).