Skip to Content
Former Member
Aug 11, 2011 at 02:41 PM

Date conversion from Excel to the SAP format



I have created a BDC program which uploads daat from Excel sheet.

There is a date field also, the format of which can be any as per the end user (it will be one of those allowed by SAP).

However, the file will be used for execution by another user who may have a date setting which is different than that from the one in Excel.

Eg. End User's date format: DD.MM.YYYY, SAP User's date format: MM/DD/YYYY

So, how do I convert the date format from excel to the format which will be accepted by the transaction during the recording?