Want to put formatted string into SAP

Help Studio
, ,
1

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

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

2

@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 ?

3

image

yes i am geeting it as above

4

@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”)

5

Yeah it worked thanks buddy :slight_smile:

1 Like
6

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