Check if Date1 is a few days more than Date2

Help
1

Hi guys,

I learnt from other post on the following expression to compare if Date2 is more than Date1 plus 1 year time:
Date1.AddYears(1)<Date2

Can anyone kindly share with me if I wanted to compare Date2 is more than Date1 plus 30 days, how should I draft the expression?

At first I thought it is something like: Date1.AddDays(30)<Date2
But it is not correct :joy:

PS: My Date1 and Date2 are stored in this format : 09-OCT-2019

Thanks!

2

Use this
DateDiff(DateInterval.Day,DateTime.ParseExact(str_Date, “dd-MMM-yyyy”, CultureInfo.InvariantCulture),DateTime.now())

3

Thanks. I actually intend to write an expression into my IF condition such as:

If Date1.AddDays(30) <= Date2
then …

In this case, Could advise me on the way to write expression?

1 Like
4

are you reading from the datatable?

5

Date1 read from data table (extracted from Excel)
Date2 read from system date (aligned the format with Date1)

6

Hi,

Try something like this,

DateDiff(DateInterval.Day, DateTime.ParseExact(date1, “dd-MMM-yyyy”, System.Globalization.CultureInfo.InvariantCulture),DateTime.ParseExact(date2, “dd-MMM-yyyy”, System.Globalization.CultureInfo.InvariantCulture)) < 30

Here my date1 and date2 are string datatype variables which holds date values.

Have to import System.Globalization namespace in UiPath Imports section to use CultureInfo.

7

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