fali1
(Fali1)
January 24, 2023, 2:47pm
#1
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)
January 24, 2023, 2:54pm
#2
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
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
…
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
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 G)
January 24, 2023, 4:53pm
#3
@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)
January 24, 2023, 5:00pm
#4
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