Want to put formatted string into SAP

I am having start date and end date in excel file as below

but while inserting into SAP its going as 01/01/2017 , please help me with this.

@amruta_pawar Are you using a For Each row to get the Value form each row of the Excel ? If So, Can you show us what is the value of row(“Start Date”).ToString an row(“End Date”).ToString ?


yes i am geeting it as above

@amruta_pawar Can you use this value and try :
DateTime.ParseExact(Split(row(“Start Date”).ToString.Trim)(0),“MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

Yeah it worked thanks buddy :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.