Skip to Content
avatar image
Former Member

conversion of date format from 2015/09/24 00:00:00 to 24/09/2015 in webi report

Hi experts ,

conversion of date format from 2015/09/24 00:00:00 to  24/09/2015 .

the data is coming from bex query for object  [CAL_Days]  , Type : Date.

It may be simple .but please help me.. urgent .

iam attaching the sample data

Thanks...

Regards

Nikil

dates.PNG (2.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2015 at 06:14 AM

    Hi Nikil,

    Please use below formula in WebI:

    = FormatDate( [date object] ; "dd/MM/yyyy")


    In your case, replace [date object] with your [CAL_Days] object.


    Regards,

    Aashutosh


    Note: For additional information you may refer : How to use formulae to change date and time formats in WebIntelligence

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2015 at 06:25 AM

    Hi Aashtosh ,

    Thanks for the reply,

    =FormatDate([Day];dd/MM/yyyy)

    i am getting the error as

    An internal  error occured while calling ' process Variable API. (Error : ERR_WIS_30270).

    Thnaks

    Nikil.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member AMIT KUMAR


      Hi Amit ,

      Thanks , we need uncheck the snap grid option at icon settings(beside to data icon ) -> options Now i am able to drag n drop and able add all other tables  n charts.

      Regards,

      Nikil

  • avatar image
    Former Member
    Oct 15, 2015 at 06:06 AM

    Hi Nikil,

    Hope this function works "TODATE(substr([0calday];0;9);DD/MM/YYYY)"

    Regards,

    KK

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Nikil,

      There is a possibility to apply offset at Bex query level.Ask your BI consultant to create a formula for Calday, inside the formula create formula vairable with reference char as 0CALDAY to consider the first 9 char(Offset) so that you may get only the date and then you can apply Format date or todate at your webi end.

      in my project we truncated at cube level to avoid such kind of issues as calday would be useful in several cases.if the implementation.

      Can you please let us know in which way you are connecting bex query if it through BICS then date comes as String.if you are using IDT you can change the data type i guess.

      Regards,

      KK

  • avatar image
    Former Member
    Oct 15, 2015 at 09:42 AM

    Hi All ,

    Thanks for the reply.

      i have done the changes ,it working .

    @ Amit Thanks

    @Ashutosh format date option is also working . Thanks.

    Thanks

    Nikil.

    Add comment
    10|10000 characters needed characters exceeded