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.
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?
1 person found this helpful
localedefinitions.xml contains and controls that for your environment
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?