formatTimePeriod Function | Vantage CX - 1.4 - formatTimePeriod - Vantage Customer Experience

Vantage Customer Experience User Guide

Product
Vantage Customer Experience
Release Number
1.4
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-3800-099K
Language
English (United States)

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