Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE12c: Formatting date mask for dd/mm/yy

Received Response
115
Views
4
Comments
OracleUser_MUC6U
OracleUser_MUC6U Rank 5 - Community Champion
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

Hi,

I want to format a date in OBIEE answers to dd/mm/yy in the users locale.  The nearest I can get is using the custom formatting mask of [FMT:dateShort]  i.e (dd/mm/yyyy) in column properties -> data format. Anyone know if there is a formatting mask which formats to dd/mm/yy in users locale?

Thanks

Answers

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Within Column Properties-->Data Format-->"Date Format" select Custom-->Then in "Custom Date Format" mention format as dd/MM/yy , put this exact format

    This should give you required format.

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    Thanks Syed.

    I need the date format to change when the user's locale changes.  So the format you have given would be fine say for UK locale as it formats to 15/06/17, however once the locale is changed to US I need it to format as 06/15/17 which the above doesn't give?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    localedefinitions.xml contains and controls that for your environment

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    Thanks Christian

    I added a new date format property <property name="dateShortYearFormat">M/d/yy</property> to the localedefinitions.xml file for the locales I need and restarted all services, though its not taking effect/showing up in the Data properties -> Data Format = Custom. I set Custom Data Format = [FMT:dateShortYear]  but no good.  Maybe the dateShortYear needs defined somewhere else ( I don't see anything revelant in localecharactersetlists.xml or localemappings.xml) Any ideas?