Objective: To Trigger a mail to a candidate whose password has been expired (45 Days).

 

Solutions: BOT developed to send the mail to a candidate whose password is not reset since from 45 days or else the company policy, we need to take the data from the database, the date format is in the format of YYYY-mm-dd but UiPath format is mm/dd/YYYY, we need to parse the data convert the format. For the solution of mail triggering to all candidate is first there were two tables we are retrieving, we have joined the table into one table and written a condition in query