Date Difference

Help
1

Hi Friends,
I have to calculate the difference between the dates.
e.g Start date :- 05/12/2011
End date;- 07/12/2012

then output should be:- 368 days.
then how i do in uipath.

Regards,

2

Hi @Rup_1

You can use the DateDiff.
Use following code(example)
DateDiff(DateInterval.Day, “05-12-2011”,“07/12/2012”)

this activity returns the number of days difference between 2 dates.

Hope It helps!

Regards,
Naveen

1 Like
3

Hi,
I used above syntax it gives me error:-

image
image1920×1080 242 KB

Please guide me on this.
Variable type is Int 32.

4

Hi @Jayesh_678,

Try this

(EndDate - StartDate).TotalDays
5

Hi,
It is correctly calculating but giving output in decimal numbers.
Untitled

6

@Jayesh_678

This will work
(EndDate.Date - StartDate.Date).TotalDays

1 Like
7

I want output as a integer, number of days.

8

start date = 05/12/2011
End date = 07/12/2012
Create Variable of type (DateTime)
DateTimeStart = DateTime.Parse(start date)
DateTimeEnd = DateTime.Parse(End date)
MonthDifference Int type variable
MonthDifference = 12 * (DateTimeEnd.Year - DateTimeStart.Year) + DateTimeEnd.Month - DateTimeStart.Month

@Jayesh_678 Cheers

1 Like
9

This is working correctly. Thanks for your quick response.

10

Most Welcome @Jayesh_678 :slightly_smiling_face:

11

Hi,
There is an issue. Bot is unable to calculate the date difference for 2020 dates. Till 2019 dates, it is calculating perfectly.
But i want the date diff for 2020 dates also.
Please guide me on this.
@ClaytonM

12

@Jayesh_678 What is the issue and how do you pass the date?

13

Hi,

Try Microsoft.Activities package:

image

You can put start date and end date (datetime variable) in properties and you will receive int as a diff between those two in output