Doing Date Subtraction in Excel

Help Community
, ,
1

I have a column(“Date”) in Excel with some Dates
Example:
4/6/2023
4/6/2022
4/6/2021

I read this Excel as Data Table by Uipath
I created an Assign with:
DayNow =
DateTime.Now.AddDays(+0).ToString(“MM/dd/yyyy 00:00:00”)

And I made the following logic.

if CurrentRow(“Date”).ToString <= DayNow

So, if the Excel Date is Less than or Equal to today, it will return some specific value in another column.
Example: If the date is less than today = CRITICAL
else : WARNING

However, when I run the IF, the logic understands today and does the right procedure, but in the case of changing the year like: 2021, 2023 and others, the logic does not work

My doubt is, do I have to take the Excel column(“Date”) and transform a datetime to be able to make this comparison between dates and years?

2

Hey!

Try like this

CDate(CurrentRow(“Date”).ToString)(“dd-MM-yyyy”)<Now.ToString(“dd-MM-yyyy”)

Regards,
NaNi

3

Yes

Let’s assume first digit is the month and the values are within the data table similar to excel
grafik

otherwise we use ParseExact to get more control (e.g. first digit is day)
grafik

And for checking what is inside the data table after read range / adopting the parsing format we can do:
:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

4

Error ERR Compiler error(s) encountered processing expression “CDate(CurrentRow(“Data de admissão sugerida”).ToString(“dd-MM-aaaa”)<Now.ToString(“dd-MM-aaaa”)”.
‘)’ expected.

5

Updated the above expression

Try it and let me know

Regards,
NaNi

6

Hi @Hendrix_Santos,

Make sure that the two values you are comparing are in date format.

CDate(CDate(CurrentRow("Date").ToString).ToString("MM/dd/yyyy"))<CDate(Now.ToString("MM/dd/yyyy"))

Regards,
MY

7

Error ERRO Compiler error(s) encountered processing expression “CDate(CDate(CurrentRow(“Data de admissão sugerida”)).ToString(“MM/dd/yyyy”))<CDate(DiaHoje.ToString(“MM/dd/yyyy”))”.
Option Strict On disallows implicit conversions from ‘String’ to ‘System.IFormatProvider’.

8

I guess Currentrow may not be coming in a format to convert to date. Can you try the code above again? I added toString at the end of CurrentRow.

9

I made some adjustments and apparently it works, I will check more calmly and make sure of this logic. Thank you very much.

1 Like
10

I believe it’s the last mistake

If: Conversion from string “” to type ‘Date’ is not valid.

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.