This article explains about the process of pushing the TDV ADD_MONTHS function into the SQL Server data source.

The corresponding SQL Server function for the TDV ADD_MONTH () is DATEADD(datepart, number, date) function .
Example:

TDV: ADD_MONTHS('2012-06-01', 3)
SQL Server: DATEADD(month, 3, '2012-06-01')

<common:attribute xmlns:common="http://www.compositesw.com/services/system/util/common">
<common:name>/custom/ADD_MONTHS(@date,~number)</common:name>
<common:type>STRING</common:type>
<common:value>DATEADD(month,$2,$1)</common:value>
<common:configID>ADD_MONTHS(@date,~number)</common:configID>
</common:attribute>
<ns1:attribute xmlns:ns1="http://www.compositesw.com/services/system/util/common">
<ns1:name>/custom/ADD_MONTHS(@timestamp,~number)</ns1:name>
<ns1:type>STRING</ns1:type>
<ns1:value>DATEADD(month,$2,$1) </ns1:value>
<ns1:configID>ADD_MONTHS(@timestamp,~number)</ns1:configID>
</ns1:attribute