Hii, My Excel sheet column is having date in US format but when my BOT after Reading the excel writes it into Webpage TextField it is Writing in Indian Format with time as 00:00:00 which i not there in excel sheet ,it only has date in US Format.webpage is throwing error. My UiPath is inside citrix…

Hi, which is your webpage expected format, Indian format or US format?

Hi, Get your date from the excel as string and convert it as date in assign activity as below Assign to a date variable: Convert.ToDateTime(dt.Rows(0)(“YourDate”).ToString).Date Then while feeding it in your website convert your date as below DateTime.ParseExact(convertedDate.ToString(“MM/dd/yyy…

while type into date into field define date format which ever you want example: date.tostring(“dd/MMM/yyyy/hh/ss”)

i am extracting it as row(2).tostring(“yyyy-mm-dd”) but it is throwing an error that implicit conversion not allowed from string to int.

Try like this, convert the table value first to date datatype Convert.ToDateTime(row(2)(“YourDate”).ToString).Date then convert it to your target format as below DateTime.ParseExact(convertedDate.ToString(“MM/dd/yyyy”), “MM/dd/yyyy”, Nothing).ToString(“yyyy-mm-dd”)

i can´t give any specific date in YourDate as My Bot will be extracting the Highest date from the excel column…i.e. it can 30 or 31

then you will get the highest date as a string right, convert that to date then proceed the second step

Hi , I have stored my Highest date as MaxDate=readDT.AsEnumerable().Max(Function (a) DateTime.Parse(a.Item(“Trade Date”).ToString)).ToString

Assign Activity: Date dateValue = Convert.ToDateTime(MaxDate.ToString).Date then convert it to your target format as below DateTime.ParseExact(dateValue .ToString(“MM/dd/yyyy”), “MM/dd/yyyy”, Nothing).ToString(“yyyy-mm-dd”)

Writing date in Wrong Format

Help

sarathi125 (Parthasarathi) June 18, 2018, 2:28pm 18

DateTime.ParseExact(dateValue .ToString(“MM/dd/yyyy”), “MM/dd/yyyy”, Nothing).ToString(“yyyy-MM-dd”)

in the format change mm to MM

Change date from excel

Topic		Replies	Views
Read and write date from excel to web using uipath Studio	8	191	November 8, 2024
Why is showing like that? Studio studio , question , activities_panel	12	550	August 19, 2023
Change date from excel Help	6	2602	July 30, 2018
Assign: Conversion from string "29-04-2022" to type 'Date' is not valid Forum excel , activities , studio , question	6	1628	July 21, 2022
Problems in DateTime Help	26	6044	May 29, 2018

Writing date in Wrong Format

Related topics