Verify the Difference between two dates

[shruthi_arali]

Hi,

I am fetching 2 dates from web application and storing it in a variable.

1. “NOC Valid From” date is stored in “validFrom” variable.
2. “NOC Valid to” date is stored in “validTo” variable.
3. validFrom value = 13-Oct-2022
4. validTo value = 12-Oct-2023

Validation

1. I want to verify difference between above 2 dates is 1 year.

please help

[Gokul001 (Gokul Balaji)]

HI @shruthi_arali

Try with this expression

DateDifference = DateDiff(DateInterval.Day, Convert.todatetime(“13-Oct-2022”), Convert.todatetime(“12-Oct-2023”))

Check out this blog

How to calculate the difference between two dates in UiPath - RPA Learners

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Output @shruthi_arali

[shruthi_arali]

@Gokul001

DateDifference

what should be the variable type of DateDifference.

[Rahul_Unnikrishnan]

Hello @shruthi_arali

If you want to directly use the activity instead of LINQ, then you can try the Modify Date activity.

How to Modify Date in UiPath? Modify Date activity explained with demo

Thanks

[Gokul001 (Gokul Balaji)]

It should be - DateDifference variable to Int64 @shruthi_arali

Regards
Gokul

[shruthi_arali]

@Gokul001

Getting below error when i used variable as int32 for dateDiff

[Gokul001 (Gokul Balaji)]

You variable type Int64 @shruthi_arali

Click on the Browser Types

Search for Int64

[shruthi_arali]

@Gokul001

I have used type int64

1. NOCvalidFrom - String - value 12-Oct-2022
2. NOCvalidTo - String - value 13-Oct-2022
3. dateDiff -int64
   formula :–> dateDiff = DateDiff(DateInterval.Day, Convert.todatetime(NOCvalidFrom), Convert.todatetime(NOCvalidTo))
   
   

[Gokul001 (Gokul Balaji)]

Check out this XAML file @shruthi_arali

Main.xaml (6.6 KB)

[shruthi_arali]

thank you @Gokul001 … Its working fine…