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

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