Date format in excel and output data table values are different

Hi need some help here regarding about the excel date in cell and the value output in UiPath output data table.

My excel date value is shown below

However, in my UiPath output data table shown below. Some rows have “00:00:00” where some rows just the date “27/1/2023”

Anyone know where when wrong?

It seems like the Format of a specific value is in String in Excel. Other rows are in date format.
Try changing the entire column format ae date or text in an excel file.

Hi @Waka

This is normal when you read a excel file with date some will be changed with date time format

You can convert them while looping using this data using this expression

DateTime.ParseExact(CurrentRow("DATE IN").ToString,{"MM/dd/yyyy hh:mm:ss","dd/M/yyyy","dd/MM/yyyy hh:mm:ss","dd.MM.yyyy","dd.MM.yyyy hh:mm:ss"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).Tostring("dd.MM.yyyy")

If you want to change the formats is the excel you can use formet Cell activity