Comparing the Date that read from excel

[Andy_Chow]

I got a date data read from excel in string format, and I want to compare today date or other date read from the datasheet.
How should I get the results?
I cannot directly minus the string and “cdate” doesnt work:
Read Cell: StringConverter cannot convert from System.DateTime.

[pattyricarte (Patty Boy)]

Hi @Andy_Chow

can you check these thread if it is applicable for your issue.

How to compare date is <=today

Hi @thima In case you are going to use “Compare date” activity, you will need to install Workflow Manager Activities package via Manage Packages. [compare%20date]

cheers
Happy learning

[Andy_Chow]

I heard I can also use datediff?
but it keeps saying Read Cell: StringConverter cannot convert from System.DateTime.

[pattyricarte (Patty Boy)]

Hi @Andy_Chow

Can you do me a favor can you screenshot your code .

thank you.

cheers

Happy learning:D

[Andy_Chow]

datediff(dateinterval.Day, convert.ToDateTime(date1), convert.ToDateTime(date2)).ToString

[Andy_Chow]

or maybe the format of the date read from the excel is already in datetime format?

[pattyricarte (Patty Boy)]

Hi @Andy_Chow

Did you try to debug it,what activity that cause the error?

cheers

Happy learning

[Andy_Chow]

the error before is fixed by selecting preserve format
but no still cannot calculate the diff between date and today
datediff(dateinterval.day, convert.todatetime(date1), now.date)

[Parth_Doshi]

This video will solve your problem @Andy_Chow : Learn How To Compare Dates In UiPath - YouTube

Mark it as a solution if it works.

Cheers,
Parth