Oracle Analytics and AI

Ja Cobelias

Summary

Parameter Date Formatting

Content

In XML Publisher template, how can I format the date parameter to DD-Mon-YYYY format?

<?param@begin: p_start_date?>Start Date -  <?xdofx:substr($p_start_date,1,4) || '-' || substr($p_start_date, 6,2) || '-' || substr($p_start_date, 9,2)?>

With the above format, my output is 2017-09-18, expected output is  18-May-2017

I have even tried with <? xdofx:p_start_date('DD-Mon-YYYY’)?> and <?xdofx:to_char($p_start_date,'DD-MON-YYY')?> but the output is  2017-09-18

​

Brajesh Shukla-95078

If p_start_date is in canonical date format then you can use to_date in rtf

example if p_start_date is '2017-05-31T11:37:01.262+00:00' then you can use <?xdofx:to_date(p_start_date,'dd-MMM-yyyy')?>