2 Replies Latest reply on May 19, 2017 10:58 AM by jincy.george.0

    SAP HANA Live View - Date Errors

    jincy.george.0

      Hi All,

       

      I am connecting to a live SAP HANA view where the date fields come in as String data type. I am trying to convert them to Date format but I am getting following error (attached)

       

      All I am doing is wrapping the column with the datetime function.

      DATETIME(right([Zglpstndt],2)+"/"+mid([Zglpstndt],5,2)+"/"+

      left([Zglpstndt],4))

       

      If I convert the datasource to an extract, this calculation works. The only thing I observed was this date field was a Unicode character string remote type when connecting live but on converting to an extract it changed to

      ANSI character string.

       

      Has anyone faced this issue? Please advise.