Date Manipulation

Communication Cloud Service lets you configure manipulation of date type data using transform feature. For example, Policy Maturity date can be derived based on the Policy Start Date and the Policy period.

You can derive the new date by adding years, months, days. For addition and subtraction operations use different <comms-data> configuration.

Note:

The order of manipulation is Year, Month, and Day.

Syntax

For Add function:

<comms-data>$Data{"Id":" UPDATED_DATE","Type":"Date"}<comms-transform type="datesum" year="true" month="true" day="true"><comms-data>$Data{"Id":"MORE_YEARS","Type":"Number"}</comms-data><comms-data>$Data{"Id":"MORE_MONTHS","Type":"Number"}</comms-data><comms-data>$Data{"Id":"MORE_DAYS","Type":"Number"}</comms-data></comms-transform></comms-data>

For Subtract function:

<comms-data>$Data{"Id":"UPDATED_DATE","Type":"Date"}<comms-transform type="datesubtraction" year="true" month="false" day="false"><comms-data>$Data{"Id":"MORE_YEARS","Type":"Number"}</comms-data></comms-transform></comms-data>