Oracle Analytics Cloud and Server

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

wrong display of date in the BIP report

Received Response
31
Views
4
Comments
C E
C E Rank 3 - Community Apprentice

Summary

wrong display of date in the BIP report

Content

          I need to display date in my report.I have given format as DD/MM/YYYY.

         

          '31-12-9999' is displayed as '31-12-1999'.Kindly help me to resolve this.

          Will i face some other issue in displaying date if i give this format.

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    use :<?xdoxslt:sysdate("MM/DD/YYYY")?>, Thanks

    let me know if you have any issues.

  • C E
    C E Rank 3 - Community Apprentice

    Hi,

        Thank you for your reply.

         I used ''MM/DD/RRRR". Then it was displayed properly as '31/12/9999'.

  • C E
    C E Rank 3 - Community Apprentice

    Hi All,

           When i used  ''MM/DD/RRRR" date was properly displayed as '31/12/9999'. But still in export copies am getting Special character ######.

          And some dates are printed as 02/04/RRRR.

          Please help me.

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    post what exactly your backend data for field the look like and what formula you applied on field? Thanks