1. Open the greenplum_4_3_values.xml file located under "[TDV Server Installation Directory] \conf\adapters\system\greenplum_4_3\" folder in a text editor.
2. Append the following code at the end of the file.
<common:attributes xmlns:common="http://www.compositesw.com/services/system/util/common">
<common:attribute xmlns:common="http://www.compositesw.com/services/system/util/common">
<common:name>/custom/DATE_TRUNC(~string,~date)</common:name>
<common:type>STRING</common:type>
<common:value>DATE_TRUNC($1,$2)</common:value>
<common:configID>DATE_TRUNC(~string,~date)</common:configID>
</common:attribute>
<ns1:attribute xmlns:ns1="http://www.compositesw.com/services/system/util/common">
<ns1:name>/custom/DATE_TRUNC(~any,~any)</ns1:name>
<ns1:type>STRING</ns1:type>
<ns1:value>DATE_TRUNC($1,$2)</ns1:value>
<ns1:configID>DATE_TRUNC(~any,~any)</ns1:configID>
</ns1:attribute></common:attributes>
3. Save the file and restart the TDV Server and Repository services.