Skip to Content
1
Former Member
Jun 13, 2016 at 10:35 AM

Datatype 'Date' not fully supported?

322 Views

Hi,

during my work I encountered a Date-Issue. I want to simply request data from the HANA and pushes it into a DateTime-Input-Field. The Data is requested by a Stored Procedure and the Result-Scheme is set properly (I receive the data without any Problems).

Type.hdbdd

type returnDate {

ID : Integer;

Date : hana.DATE;

};


XML

<DateTimeInput dateValue="{myModel>/Date}" enabled="true" id="Date_id" name="Date"/>

It seems, that hana.DATE (also Datetime, Date or hana.Datetime) is not supported. -->

[12:17:59] Error while activating /development/projects/data/Types.hdbdd:
[development.projects.data:Types.hdbdd] Sub artifact "DATE" not found in "sap.cds.hana"

If I switch to

  • Timestamp
  • UTCTimestamp
  • LocalDate

I get the following Error:

sap-ui-core.js:152 Uncaught Error: Type Error: Expected JavaScript Date Object for property dateValue of Element sap.m.DateTimeInput#__xmlview0--Date_id

If I change the Value to an oData-Type like:

<DateTimeInput dateValue="{path: 'myModel>/Date', type: 'sap.ui.model.odata.type.DateTime', constraints: {displayFormat: 'Date', nullable: false}}" enabled="true" id="Date_id" name="Date"/>


The Input Field is still empty, but without any Error-Message.



Please help me 😊