Skip to Content
0
Aug 16, 2017 at 10:54 AM

WEBI DATE Format

294 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

Attachments

date.png (19.7 kB)