How to change the default date format from MM-DD-YYY (American) to DD-MM-YYYY (European) in OTBI — Oracle Analytics

Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How to change the default date format from MM-DD-YYY (American) to DD-MM-YYYY (European) in OTBI

Received Response
495
Views
1
Comments
Bert.Borst
Bert.Borst Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

The default date-format in OTBI is MM-DD-YYY.

In Europe we use DD-MM-YYYY.

Now we need to modify all date columns and change the format of the column. But if we could change the default date-format, then we do not need to change this.

(Also strange that OTBI is not using the preferences that you do set on user level in the ERP-system)

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi,

    In OTBI the date format IS taken from your preferences in Oracle Fusion Cloud Applications.

    Both the American and European date formats are bad because they are ambiguous for the first 12 days of each month which is about 39% of the days in a year. The better format to use is the international oraganization for standards ISO format YYYY-MM-DD which added bonus also sorts correctly to.

    Anyway if you set your date format in General Preferences Regional in Fusion Applications then it gets used as the date format "Locale Short/Long" in your analysis / publisher report in OTBI. Each user using the same analytics and reports will get a different date format as per their user preference in FA.


    image.png