SAP Knowledge Base Article - Public

3312777 - Using the Paste Product's information from Excel into a Sales Quote, but Wrong Date is returned.


You are using the paste Product's information function from Excel to a Sales Quote.

All values are being copied correctly, except for the date column.

Every time you paste a date into the date column with format DD.MM.YYYY, it returns the value: 01.01.1970.


SAP Cloud for Customer

Reproducing the Issue

  1. Log into C4C;
  2. Go to Sales Quote view;
  3. Go to Products facet;
  4. Paste the product from Excel file with format DD.MM.YYYY;
  5. Observe: Date got changed to 01.01.1970 after pasting the product.


01.01.1970 is the default date when there is no value pasted for a date field.

In this case, customer is using the wrong date format - DD.MM.YYYY.

So, the root cause of the issue is that the format in which the date is passed is wrong - it should be as follows YYYY-MM-DD e.g.: "2014-11-15".


Kindly change the date format, it should be as follows YYYY-MM-DD e.g.: "2014-11-15".


Paste Products; Excel; Sales Quote; Date format; wrong , KBA , AP-RC-UIF-RT , UI Framework Runtime , How To


SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications 2211