Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to get the date formant in RTF Template

Question
32
Views
0
Comments

Summary

need to bring date formant in rtf template. if i take sysdate i am able to see the data whereas parameter date is not showing in rtf template.

Content

Hi,

need to bring date formant in rtf template. if i take sysdate i am able to see the data whereas parameter date is not showing in rtf template.

can anyone let me know how i need to get the data. what ever user selected in parameter that date should show in :P_DATE_ON field.

for-each

Date

<?xdofx:to_char(‘:P_DATE_ON’),'DD/MM/YYYY')?>

 

 

 

 

To ,

 

 

CUSTOMER_NAME_D

ADDRESS1

ADDRESS2

CITY

COUNTRY_NAME

 

 

 

 

Fax No :

FAX_NUM

 

Attn :

 

 

 

 

 

 

 

 

Sub :  Confirmation of Outstanding Payment Due to us.

 

 

The balance due to us from your company as per our books of accounts stands at Dhs BALANCE_AMOUNT as on <?xdofx:to_char(:P_AS_ON_DT,'DD/MM/YYYY')?>. Kindly confirm the same in the space provided at the end of this letter.