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