Get difference for two dates in Months and Days

[Palaniyappan (Palaniyappan P)]

Hi
These are the expression you can use in assign activity

In days

int_days = DateDiff(DateInterval.Day, DateTime.ParseExact(Strinput.ToString, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture),DateTime.now())

Output type is int32
Input you can pass the string to variable named Strinput = “17/09/2022”

In months

int_months = DateDiff(DateInterval.Month, DateTime.ParseExact(Strinput.ToString, “dd-MMM-yyyy”, System.Globalization.CultureInfo.InvariantCulture),DateTime.now())

Output type is int32

You can get to know all sort of Datetime expressions from this post

All about Datetime - UiPath

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 feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm…

Hope this helps

Cheers @aqiffm