Number of days between two dates. Example = (12/17/2022, 12/9/2021) = 373 days

Hi @kapil.k2 ,

You can do either of the below 3 methods.

• Use a calendar table in a database

or

• Use VB/Java/python script

or 

• Use Difference between two dates package from bot store.

Hope of this will help.

Hi @kapil.k2 

1. Use below botstore package for a simple solution.

https://botstore.automationanywhere.com/bot/automation-360-difference-between-two-dates-package

2. Checkout below tutorial to import the bot package from botstore.

3. Search for DifferencebetweenTwoDates package from the Actions pane

4. 

   You can retrieve the difference between two dates in days format by using the DifferenceBetweenTwoDates: Difference between two dates in Days command and provide the First Date and Second Date as well as the Date Format. The output should be assigned to a string variable as below