Skip to Content

SAP date format needs to be converted to WEBI date format

Feb 21, 2017 at 02:21 AM


avatar image

Hi All,

I am using HANA view to create WEBI report. The date field from HANA view is coming as YYYYMMDD format. I am now trying to make it to WEBI format using ToDate([created_on];"ddmmyyyy") but i am not getting the desired result. is there anything i am missing? Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Feb 21, 2017 at 09:37 AM

if your Date object datatype is string in HANA then use this in webi. Month format should in the Caps "MM"


Show 1 Share
10 |10000 characters needed characters left characters exceeded

sorry, it is giving me the error. "#Error" but i tried with =ToDate([Creation date of the work item];"yyyyMMdd") as the incoming hana string is in the format of YYYYMMDD, it worked. The string should match with the incoming date string, then it works. Thanks Amit.