Can any one help in displaying the date in BI publishing report as per locale?
For example, if the client is sitting at US, the date should be displayed as mm/dd/yyyy
and if the client sit at India, the date should be as dd/mm/yyyy format.
Thanks in advance
Use the following example and replace hiredate with the element name containing date in canonical date format: 2005-01-01T09:30:10-07:00
SHORT is for Short date format but also can use MEDIUM or LONG
The report locale gets set when running the report or uses the default locale depending on what mechanism you are using to run the reports.
Edited by: dpoulter on Nov 28, 2011 3:11 PM