SAP Knowledge Base Article - Preview

3207581 - Date is changed to date -1 day when copied from Excel


Copying/pasting a date from Excel to an UI5 smart table column that uses a datepicker causes the date to be replaced by the date minus 1 day. For example, if the date in Excel is 29-01-2022, the date that gets displayed in the table is 28-01-2022.



SAP UI5 1.84.21


SAP S/4HANA 1909


date picker, smarttable, table , KBA , CA-UI5-TBL , SAP UI5 table, smart table, list and tree controls , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.