The default Date format of webi reports is mm/dd/yy
I wish to change the default date format to mm/dd/yyyy so that whenever
i drag a date from the universe it is automatically displayed in this format
and i dont have to manually format it everytime.
Is there anywhere where the default date format for all reports in webi can
be changed. and changes in xml files.
One way is..
In the universe Designer, go to tools > options > General TAB > Choose the English Button. Scroll down to the unsupported languages. Select English Australian, or New Zealand as needed. This will force the date object to reflect that format for all reports on that universe.
I want the default format when i pull a date value in a webi report to be mm/dd//yyyy
so that when translation is done into other locales the same date format is maintained.
for eg in japanese the format should be yyyy/dd/mm. This will happen only if the default in english is set to
Now when i pull the value it shows is in dd/mm/yy format.I can format the cell and convert the format to mm/dd/yyyy,but
i want a technique where by default it is mm/dd/yyyy
There are few setting in your webi Preference Tab which we need to take care.
Just check what preference you have under
Web intelligent > When viewing a Document
Use the document locale to format the data
- If this is selected than what ever the Local setting for the Document creation system it will come
Use my preferred viewing locale to format the data
You can view data as per your local setting
Idly it should be u201CUse the document locale to format the datau201D.
Now change your machine locate date formate.
Hope this may help you out.
It will be better you can change the format at Universe level, do right click on the object at universe level and change the format.
Note: this will change the display of the date in dd/mm/yyyy. But in list of value date will be dd/mm/yy only.
Thanks & Regards,
Hope you must have discovered the answer to this as its been a long time you posted this.
Just for the Users who are looking out for this answer :
We can use FormatDate Function for this :
Returns "15/12/2005" if the current date is 15