4 Replies Latest reply: Mar 4, 2011 3:51 PM by Swarna K RSS

to change the default date format in Webi

Subash P
Currently Being Moderated

HI All,

 

            I had a requirement to change the default date format in webi. i.e I want to diaplay the time along with the date in the report. BUt when i change the syntax of the date in the report level with the custom format it is not getting localized.

So my requirement is i need to change the display format of the date in the report along with the time and at the same time the report should get localized. In one of the forums i read that by changing the format of date in files which are there in the business objects folder which comes with the installation. I dont know exact name of that file. Can any one of you please help me out in the issue.

 

Thanks,

Subash

  • Re: to change the default date format in Webi
    Vrushali Phulphagar
    Currently Being Moderated

    Hi Subhash,

     

    You can change the default date format in webi as follows:

     

    Goto Tools-> Options and Locale

    Here you can select the region eg. English (United Kingdom) as per your location.

     

    Hope this helps.

    • Re: to change the default date format in Webi
      Subash P
      Currently Being Moderated

      Hi,

            Thanks for your reply. But this will not resolve my issue. Actually what i am looking is need to change the default syntax which is going to display in the webi reports. There is an option of changing the syntax in web.xml file in business objects folder which will change the format of the date which is getting displayed in the prompt. Like that is there file where we can change the dafault format of the date so that the date fromat will get changed in webi. My issue i need to display date , time .

       

      Guys waiting for your response....

       

       

      Thanks,

      Subash

  • Re: to change the default date format in Webi
    Rachna Jain
    Currently Being Moderated

    Try to change the date formate in PRM file the location of PRM file is

    <INSTALLDIR>\dataAccess\RDBMS\connectionServer\<rdbms>\

    There will be 2 types of parameter for date. Jus check and change it for the local parameter.

     

    File will be in your Server, where you have installed your BO server. Also, if you change this parameter, change will  impact on each and every reports using this perticular RDBMS. Jus check if you are Ok with this.

  • Re: to change the default date format in Webi
    Swarna K
    Currently Being Moderated

    Hi,

     

    In WebI, you can use the formula

     

    =FormatDate([Date];"ddth Mmm yyyy")

    to get the desired date format.

    If the object is of type Character and retuns the date in format dd/MM/yyyy, then you have to convert it into a date before using FormatDate function. In this case you can use the formula

    =FormatDate(ToDate([Date];"dd/MM/yyyy");"ddth Mmm yyyy")

     

Actions