I have a data table which has a column(Ex-Date of Joining) with the data like 07-04-2019 19:30:00(dd-MM-yyyy hh:mm:ss). I want to changes this 07-04-2019 19:30:00 format to 07-04-2019 (dd-MM-yyyy) for a whole column in the data table. I don’t want to use for each row activity because it contains 4000+ records. it takes more time. i want to do this efficiently. please help me to resolve this issue.
Use read range with preserve format option ticked and store the results in datatable dt1
Now use the below in invoke code with language as vb.net with argument as in/out for dt1
dt1.AsEnumerable().ToList(Sub(row) row(“Ex-Date of Joining”)= Datetime.ParseExact(row(“Ex-Date of Joining”).ToString,“dd-MM-yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy”))