Date Conversion issue in Universe based on HANA calculation View
In HANA we have field like Schedule payment date as data type as NVARCHAR, we have created universe based on HANA calculation view.
In IDT business layer when running the query with schedule payment date as prompt we are getting the error as below.
: invalid date, time or Timestamp value: search table error : attribute value is not a date or wrong syntax;
Can any one help me on this issue, as this is urgent issue we need to resolve ASAP.