Conditional date formatting

I am mainly getting date in below format but in some case i m getting date in different format(please refer to 2nd image)
image

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
image

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.

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.

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.