Hi I have a date on my excel such as 30/03/2019, I read that date and want to write it to another excel. But everytime I write it, it will be 30/03/2019 00:00:00, I only want the short date type, and the output file may change, so I dont want to set it as short data data format in the excel. I d …

solved! [image] Date formating MM/dd/yyyy 00:00:00 to yyyy-MM-dd Help Convert your string to DateTime and then format it str1=“MM/dd/yyyy 00:00:00” tempDate = Convert.ToDateTime(str1) tempDate.ToString(“yyyy-MM-dd”)

@jingwang0222 , Try like this: row(“DateColumn”).tostring(“dd/MM/yyyy”)

Hi Thanks for your advice But I already read that data from excel, so it is a variable now, I try to use variablename.tostring(“dd/MM/yyyy”), the output is the string “dd/MM/yyyy”. what do you mean by “Datacolumn”, my data table name?

Hi, you can use DateTime.Parse(yourDate).Date also you can format your date, DateTime.ParseExact(yourDate, “dd/MM/yyyy”, nothing) nothing means “use the current culture”

Hi Jesan Thanks for your idea, I have solved it from forum’s other question. I also tried yours, but because my date input is a generic value, the assign error said “string was not recognised as a valid datetime”, I tried to convert it to date time but it still not works.

Compiler error: Overload resolution failed because no accessible "ToDateTime"

Help

jingwang0222 (Jing Wang) April 4, 2019, 11:01pm 5

solved!

Topic		Replies	Views
I want to put a date in the column from uipath Activities datatable , excel , activities , studio , reframework , question	4	3058	December 29, 2021
Error in handling Date Time Values Studio excel , activities	5	1490	September 14, 2020
Read Date from Excel into DateTime Studio excel , variable , question	10	5727	August 6, 2020
Convert date format-month Learning Hub datatable , excel , studio	28	5766	October 6, 2020
Problems in DateTime Help	26	6059	May 29, 2018

Compiler error: Overload resolution failed because no accessible "ToDateTime"

Related topics