Issues with HANA Date Type format

[#1]

I have an excel containing a several Date fields in format YYYY-MM-DD, which is the format of HANA Date data type.

When I upload to Cloud Foundry DB via the WebIDE import, or a simple paste in the DB Explorer, it is accepted, however, when I try to upload the same date to the same DB (same schema/table everything) via HANA Studio, it gives me the following error:

Unsupported date/time data used in imported data. Modify the data and import again.

dateissue.png

Data:

date-data.png

Same Data is getting uploaded from from place, but not from another place.

Now I have the following issues with Cloud Foundry Web IDE upload:

1. CF WebIDE is very unstable, and the upload gets stuck several times, wherein you can not use any other tab, and the only way out is to reload the entire WebIDE. (Business Application Studio is not subscribed in my my Subaccount)

2. Files Over 1 MB can not be uploaded over http(s) connections in my organization, and for huge data volumes, HANA Studio is the way out, since right now I do not have the provision of any data services like SDI, SLT etc. from the management.

Why would there be such a goof-up between 2 standard products of SAP?

Also, is there any format that I can upload from HANA Studio?

Also, is there a way I can download tables from ABAP SE11 to the presentation server with Date in the HANA (YYYY-MM-DD) format?

[Abhishek_Hazra]

Hi,

Have you tried to change the format to DB date format (YYYYMMDD) & upload?
Also, you have an option from HANA Studio to import data from local file like below in the quick view :

May be worth a try?

Best Regards,
Abhi

[former_member681897]

Hi Abhishek,

Yes, I have tried that format as well, and am trying to upload this way only, but without any luck.