How to extract data of people who are about to be retired from their service on attaining 65 yrs of age using UiPath Community Edition?

[chenderson (Cary Henderson)]

Good evening Moola (I think rivello beat me to the punch, but they deleted their post),

First you’ll want to get the current date:

How to get current system date in mm/dd/yyyy format?

Try this: System.DateTime.Now.ToString(“MM/dd/yyyy”)

Next you’ll want to calculate the difference between today’s date and the DOB provided in the Excel file by using the DateDiff function:

Difference between two dates

Hello! You can use the DateDiff function. Example: Syntax: DateDiff(DateInterval, Date1,Date2) Code: DateDiff(DateInterval.Day, “2016-01-30”,“2016-01-30”) It will return the number of the days between the two dates as Integer Type. Hope It helps! Regards,