Date format in excel and output data table values are different

[Waka (Andy NG)]

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?

[Gokul_Jayakumar (Gokul Jai)]

@Waka
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.

[Sudharsan_Ka]

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

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

Regards
Sudharsan