Skip to Content

SAP date format needs to be converted to WEBI date format

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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"

    =ToDate([created_on];"ddMMyyyy")

    Add comment
    10|10000 characters needed 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.