I am mainly getting date in below format but in some case i m getting date in different format(please refer to 2nd image)
I need to fix this date(2nd image) issue in run time and process the records.
I am attaching the value from DataTable below
P.S - I need to fix this in runtime, if date is okay then process if its not then fix the date issue and process.
AshwinS2
(Ashwin S)
2
Hi @indrajit.shah
Use For each row in Dt
row(“DOB”).ToString=CDate(row(“DOB”).ToString(“dd/MM/yyyy”)
Thanks
Ashwin S
1 Like
I didn’t get it.
i am already using For Each Row, then only i can able to paste data from DataTable and i have multiple date column in excel.
AshwinS2
(Ashwin S)
4
Hi @indrajit.shah
within the for each activity
use assign and give the syntax
Thanks
Ashwin S
I am getting this bellow error
the variable type is String.