Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

BI Publisher Template(RTF/eTEXT)

Received Response
41
Views
2
Comments
Prantik Mukherjee-88434
Prantik Mukherjee-88434 Rank 1 - Community Starter
in Oracle Analytics Forum

Summary

BI Publisher Template(RTF/eTEXT)

Content

Hi,

Can you please help me out with logic to populate sysdate and time over my BI Publisher Report. I know it can be done using inbuilt template builder but i want to achieve this using XDO coding in my rtf template.

Thanks

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics & AI Coach

    RTF you can write <?xdoxslt:sysdate(“DD-Mon-YYYY:HH:mm:ss”)?>

    etext : TO_CHAR(SYSDATE,'DD-MON-YYYY hh:mi:ss')

  • Zeeshan Naeem
    Zeeshan Naeem Rank 1 - Community Starter

    I think this below code is already available in sample RTF templates...

    Date: <?xdoxslt:format_date(xdoxslt:current_date($_XDOLOCALE,$_XDOTIMEZONE),'yyyy-MM-dd','yyyy-MM-dd',$_XDOLOCALE,$_XDOTIMEZONE)?> <?xdoxslt:current_time($_XDOLOCALE,$_XDOTIMEZONE)?>

      Page  Of  1