Compare two datetime variables - retrieve month differences

Help Studio
, ,
1

Hello Everybody.
Simple question i think for you but i dont’ find any strong solution until now.
I have two variables already in datetime format.
Like
date_1 = 01.01.2022
date_2 = 14.10.2022

My goal is to find if date 1 is previous month compared to date2

How can i achieve this goal?

Ex: date1 = 01.01.2022 is previous month compared to date2
date2 = 01.12.2021 is previous month compared to date2
date3 = 01.10.2021 is previous month compared to date2
date4 = 01.10.2022 is current month compared to date2

Thanks a lot guys!!

2

Hi @l.sambinelli,

Can you check out below code.
DateTimeCompare.zip (1.6 KB)

Regards,
Dibyaprakash

Mark it as solution if it resolves your issue.

3

Hi @l.sambinelli
Find the below solution
DateTimeCompare.zip (1.6 KB)

4

we can parse the date string into a date by following (kindly note some variations on the smaples)
grafik

and can use the dateDiff method for the checks (position of the parameters counts)
grafik

Kindly note: DateDiff will not return fractions of a unit and can have side effects e.g. we want to retrieve the information of “Complete of X” X - year, month…

5

thanks but i dont’ have any DateDiff function in my uipath (vb.net)

6

thanks. Result its’ not ok.
Because if you compare first date like : 01-12-2021 to today with your code the result is false like “current” month

7

@l.sambinelli

the screenshots from the answer were done within immediate panel:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

so it is done and available within UiPath / VB.Net

Have a look on the docu

Maybe you will prefer to use the full qualified method name:

grafik
grafik1021×66 21.6 KB

grafik

Also check following and add if it is missing:
grafik

9

Hi @l.sambinelli,

Can you explain what exactly you want as output.

Case1:
Let suppose date2 is current date and you want to check the first date is earlier month to current date that means it can be december of 2021

Case2:
date2 is current date and you want months which are from january to current month thats is october.

10

Hi @l.sambinelli,

Can you please check out below solution, hope this one will definitely resolve your issue.
CheckMonth.zip (1.5 KB)

Regards,
Dibyaprakash