Learning platform UI Path Description Hi I am new to UI path I have a doubt. I am getting values(dates) from excel in MM/dd/yyyy as string. I want it to be stored as date format. Because I need to compare two date. Date which I read from excel and current date. I tried this : DateTime.ParseExact…

Hi @588b97c268cd7dd244bd4707e Have you tried this? [image] Convert date format in dynamic values Robot Hi @588b97c268cd7dd244bd4707e dateString = row("YourDateColumnName").ToString parsedDate = DateTime.ParseExact(dateString, "MM/dd/yyyy", System.Globalization.CultureIn…

@588b97c268cd7dd244bd4707e Cdate(yourvaluefromexcel) this will be in dateformat…dont include .ToString…that will convert to string again Cheers

Convert dynamic values to date

Help Activities

lrtetala (Lakshman Reddy) June 16, 2024, 8:29am 2

Hi @588b97c268cd7dd244bd4707e

Have you tried this?

Regards,

Topic		Replies	Views
Convert date format in dynamic values Robot robot , question	3	151	June 16, 2024
Convert a string to Date format Activities excel , activities , question	10	9955	January 8, 2022
Convert date stocked in string value to "yyyy-MM-dd" Format Activities excel , uiautomation , activities , studio , question	5	1056	November 5, 2022
How to convert excel column (string) to date format Studio	7	3946	June 8, 2022
Create date from day, month & year Studio activities , question	7	2394	June 23, 2020

Convert dynamic values to date

Related topics