Problem with setting RTF variable with delimited date value
I am trying to set a variable using Oracle Bi Publisher Desktop RTF Templates Using the Template Builder for Word 11.1.16 in my RTF template using a date that is in YYYYMMDD format and reformating the date value with substring. Can some please steer me in the right direction.
DATUM = "YYYYMMDD" new format would be "MM/DD/YYYY"
<?xdoxslt:set_variable($_XDOCTX, 'REPORTDATE',concat(substr(DATUM,5,2) || '-' || substr(DATUM, 7,2) || '-' || substr(DATUM, 1,4) ))?>
DATUM = "YYYYMMDD" new format would be "MM/DD/YYYY"
<?xdoxslt:set_variable($_XDOCTX, 'REPORTDATE',concat(substr(DATUM,5,2) || '-' || substr(DATUM, 7,2) || '-' || substr(DATUM, 1,4) ))?>
0