OBIEE12c: Formatting date mask for dd/mm/yy

OracleUser_MUC6U

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

Syedsalmancs110

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

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]

localedefinitions.xml contains and controls that for your environment

OracleUser_MUC6U

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?