i am Unable to change the date from DD.MM.YYYY to MM/DD/YYYY.
I have used below code, Input is from excel so i have used row(“S4_Order_created_Date”):-
@keshav Can you try this expression :
Created_Date ( String ) = DateTime.ParseExact(row(“S4_Order_Created_Date”).ToString.Trim,“dd.MM.yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)
This will work if the date Format in the Excel is dd.MM.yyyy