How to change the default Date format For Webi Report

[Former Member]

hi,

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.

Thanks,

Sridhar Iyer

[Former Member · Accepted solution]

Hi,

     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 :

Syntax :

FormatDate(CurrentDate();"dd/MM/yyyy")

Output :

Returns "15/12/2005" if the current date is 15

December 2005.

[former_member213053 · Accepted solution]

This post was very helpful to me.

Thanks

[amitrathi239]

Hi,

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.

Thanks,

Amit

[Former Member]

Hi amit,

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

mm/dd/yyyy

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

Thanks,

Sridhar

[Former Member]

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.

[Former Member]

The formatting according to locales works fine.

My question is how to change the default formating of date from mm/dd/yy to mm/dd/yyyy when used in a report

[former_member136842]

Hi,

try to use the ToDate function with your Date dimension.

Regards

-Seb.

[Former Member]

If i use ToDate function the format wont change according to my locales.!

[Former Member]

Hi Sridhar,

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,

Akhil Muley