WEBI DATE Format

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