Date Format in BI report based on RTF Layout and xls as output.
Hi,
I have a custom report with one of the column being date. This report is based on RTF layout with XLS being output.
I want the report to display the date in DD-MON-YYYY format as users want to do filter on this column.
Oracle notes suggests using the below listed command.
<?xdoxslt:format_date(./AnyDate,'yyyy-MM-dd','MM/dd/yyyy', $_XDOLOCALE, $_XDOTIMEZONE)?>
Upon using the above listed command i'm getting the output 'mm/dd/yyyy hh:mm:ss format. The command on the report is listed below.
<?xdoxslt:format_date(INV_DATE,'dd-MMM-YYYY HH:mm:ss','dd-MMM-yy', $_XDOLOCALE, $_XDOTIMEZONE)?>
Let me know what I'm missing on the command line or if there is any other way to achieve the requirement.
Tagged:
0