BI Publisher (MOSC)

MOSC Banner

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center