Convert dynamic values to date

[588b97c268cd7dd244bd4707e (UI path)]

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( One , “d-M-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”) where one is the variable in string which values I am getting from excel ex: 7/2/2024.

Can someone please help we with this. I want it to store in date format so I can perform which date is recent operation.

Thankyou in advance.

Link

YouTube

Date

2024-06-14

[lrtetala (Lakshman Reddy)]

Hi @588b97c268cd7dd244bd4707e

Have you tried this?

Convert date format in dynamic values

Hi @588b97c268cd7dd244bd4707e dateString = row("YourDateColumnName").ToString parsedDate = DateTime.ParseExact(dateString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture) currentDate = DateTime.Now If parsedDate > currentDate Then ' parsedDate is more recent than currentDate Else ' currentDate is more recent or they are the same End If Regards,

Regards,

[Anil_G (Anil Gorthi)]

@588b97c268cd7dd244bd4707e

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

Cheers