Skip to Content
avatar image
Former Member

WEBI DATE Format

Aug 16, 2017 at 10:54 AM | 150 Views | Last edit Aug 16, 2017 at 10:55 AM 2 rev.

date.pngHello,

I am using BO 4.1 SP 8 Patch 4 and SAP BW as backend.

I create webi using bex query and i have objet called Timestamp which is a dimension in nature.

So the output of this object is as 15.08.2017 22.00.36.

When i applied todate function, i get error. When used format date function (=FormatDate(ToDate([Time Stamp];"d/M/yyyy hh:mm:ss"); "d/M/yyyy hh:mm:ss")) still #error appears in the cell.

I need the output as 15.08.2017.

Please help!

Thanks,

Hetal

date.png (19.7 kB)
SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    AMIT KUMAR
    Aug 17, 2017 at 09:00 AM

    try this.error comming beacuse your time format is in 24 hrours

    =ToDate([Time Stamp];"dd.MM.yyyy HH:mm:ss")

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Kuldeep Ghosh
    Aug 16, 2017 at 11:16 AM

    Try this:

    =FormatDate(ToDate([Time Stamp];""); "d/M/yyyy hh:mm:ss")

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 17, 2017 at 06:08 AM

      Hello,

      I tried the above formula and i got below msg :

      The expression or sub-expression at position 12 in the 'Format Date' function uses an invalid data type (IES 10037).

      Thanks!

  • avatar image
    AMIT KUMAR
    Aug 16, 2017 at 02:51 PM

    try this if datatype is string.

    =ToDate([Time Stamp];"dd.MM.yyyy hh:mm:ss")

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 17, 2017 at 06:17 AM

      Hello Amit,

      I tired the above formula and it worked. But in a strange manner. for few records the date is correctly displayed and for few records to shows # error as follow. In the first column Time stamp object is used and in second, the above formula is used.

      Thanks!

      Hetal

      img.png (32.6 kB)