BI Publisher-Passing Date as a parameter
I a have a requirement to pass a date parameter which will have the last day of every month, example: 06/31/2012
In my rtf i do the below:
1. declared the parameter as
2. <?namespace:psfn=http://www.oracle.com/XSL/Transform/java/com.siebel.xmlpublisher.reports.XSLFunctions?>
3. when i use the below syntax
<?for-each:LcAccountDailyHeader[(psfn:totext(RPTRunDate,"yyyy-MM-dd","MM/dd/yyyy"))=(psfn:totext($P_Date,"yyyy-MM-dd","MM/dd/yyyy"))]?>
where LcAccountDailyHeader is the group and RPTRunDate is my date field i get error when i try to preview the rtf template
I am expecting to pass 06/31/2012 as mentioned above in the $P_Date parameter.