OBIEE12c: Formatting date mask for dd/mm/yy

Question

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

OracleUser_MUC6U · Answer

Thanks Christian I added a new date format property M/d/yy 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?

[Deleted User] · Answer

localedefinitions.xml contains and controls that for your environment

OracleUser_MUC6U · Answer

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?