Dear all, I have to find the difference between the two date’s months and year. Input String: “2021-09-02”, “2022-02-12” Now I want the following list as the difference between two date Sept-2021 Oct-2021 Nov-2021 Dec-2021 Jan-2022 Feb-2022 Kindly help to find the solution. Best Regards, …

@Vrushali_Gave , Check this xaml, it will give you the result you are looking for. GetMonthsBetweenDates.xaml (6.4 KB)

Hi @Vrushali_Gave can u try the sample syntax below DateDifference = DateDiff(DateInterval.Day, Convert.todatetime(“04-25-2021”), Convert.todatetime(“01-27-2022”)) Also change DateDifference variable to Int It will return the number of the days between the two dates as Integer

@nikhil.girish Thank you for the response I want a month and year list from two date difference

you could use a do while loop? Start with your first date - then increment the month by 1 and add it to your list of strings. I would convert the strings to date first as @nikhil.girish suggested. Convert.todatetime(“04-25-2021”) Your exit condition would be if your last date added matches your …

Hi @Vrushali_Gave DateDiff(DateInterval.Month, Convert.ToDateTime( “2016-01-30”),Convert.ToDateTime(“2016-05-30”)) — for month

Hope below link helps to solve the issue.. [image] All about Datetime - UiPath Tutorials Hi All, My recent post on datatable [All About Datatable- UiPath] ( https://forum.uipath.com/t/all-about-datatable-uipath/386445 ) was received well in forum with great fee…

How to find difference between two date

Help Studio

hariapn (Hari Kumar) March 3, 2022, 10:43am 6

Hope below link helps to solve the issue..

Topic		Replies	Views
Get difference for two dates in Months and Days Studio activities , studio , string , system , date , datetime	8	1837	October 3, 2023
Date Difference by Month Help activities , studio , string , question , data-manipulation , system	9	4240	December 6, 2019
Need to find the month diff Activities datatable , excel , uiautomation , orchestrator , activities , studio , studiox , question , activities-panel	8	321	February 22, 2024
Difference between two dates Help activities , system	11	53987	August 20, 2018
Compare two datetime variables - retrieve month differences Studio studio , question , datetime-comparison	8	1281	October 14, 2022

How to find difference between two date

Related topics