BI Publisher (MOSC)

MOSC Banner

Date format in RTF Template

edited Jul 29, 2024 9:10PM in BI Publisher (MOSC) 17 commentsAnswered

Hi,

I want to change the date format in rtf template. when i am using sysdate i am getting the data based on sysdate. But i want to get the data based on the parameter date which was selected.

can anyone help me..This date im not using in header level.

This is working      -             <?xdofx:to_char(sysdate,'DD/MM/YYYY')?>

This is not working     -        

Date      

<?xdofx:to_char(AS_ON_DT ,'MM/DD/YYYY','DD/MM/YYYY' )?>

can anyone help me how to add this. please find the attached highlighted column . AS_ON_DT is the parameter used in data model.

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