Siebel Bi Publisher - Date format according to selected Report Locale
Hi,
We have Siebel with BI Publisher in 20+ countries with different Locales. Requirement is to get dates generated according to selected Report Locale.
Is it possible, having one report template get different date formats automatically e.g
selecting Report Locale = English - United States, date would be MM/DD/YYYY
selecting Report Locale = Finnish -Finland, date would be DD/MM/YYYY
or the only way is to create separate RTF template for each country and hardcode the expected date format(using xdoxslt:format_date function)?
I've tried to specify language in the XLIFF
<file source-language="fi-FI" target-language="fi-FI" datatype="XDO" original="orphan.xlf" product-version="orphan.xlf" product-name="">