nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Oracle BI Reports,in report output the dates are not coming as per the format set in user preference

User_VO7FP

We are working on Oracle BI Reports, in report output the dates are not coming as per the format set in user preferences,

Find more posts tagged with

BI Publisher

BI Publisher Report Templates

Accepted answers

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61861#Comment_61861

That's right.

Thanks.

All comments

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24086/oracle-bi-reports-in-report-output-the-dates-are-not-coming-as-per-the-format-set-in-user-preference

The dates by default are shown in date timestamp format as stored in DB. If you need any particular format, you need to define that in your BI data model query.

Thanks.

SayanDutta

we also have same requirement,

MandeepGupta

Please check sample given on below support note to convert it as per User preferences:

How To Set Date As Per User Preference Time zone in Fusion Applications BI Publisher Report (Doc ID 2864734.1)

Thanks.

User_VO7FP

@MandeepGupta so if a user changes his/her preferences say (mm-dd-yy —> dd-mm-yy) then it will not reflect automatically in BI reports ?
I have to think of a generic date format for all reports we have for this client?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61861#Comment_61861

That's right.

Thanks.

User_VO7FP

@MandeepGupta thanks for your quick reply