Ship Date format

[fali1]

Can somehelp how can I get the correct ship date format to MM/dd/yyyy. I am adding the date from an excel file which has the correct format but in the Queue its not adding in the correct way. I changed the string variable type to object, generic value but doesn’t seem to work. I get the error (Get Row Item: 44858 is not a valid value for DateTime.)

[Gokul001 (Gokul Balaji)]

HI @fali1

Before adding the data into the queue You can use Format cell activity to format the Date column in the excel file.

Check out the tutorial

[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 …

Date and month interchanged while reading from excel

HI @Jayesh_Rathi1 How about this expression? DateTime.ParseExact(CurrentRow("Column Name").ToString.Trim,"MM-dd-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy") Note : dd-MM-yyyy -> Based on excel date fomat Or You can try to change the format of the column Excel process scope activity Use excel file activity Format cell activity [image] Regards Gokul

How to change cell format as text using UiPath or excel formula

Another Method @Baby123 You can also try with Format cell activity Check out the the Tutorial Range -> Excel.Sheet("Sheet1").Range("A1") [image] Regards Gokul

Regards
Gokul

[Anil_G (Anil Gorthi)]

@fali1

I guess while reading from excel you are reading in rawvalue option…

Check in read range options and change to display value so that the data format is as needed

Cheers

[ppr (Peter Preuss)]

We would recommend to handle / harmonize the date value before adding the QueueItem / populating the Specific Content

In the case for handling this numerical value you can do:

So for robusten it up you can think about cascading the datevalues

• cell formating
• value format type check
• handling dateTime Strings
• handling OADate numbers